PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
jamrop
Forum Commoner
Posts: 80 Joined: Fri May 16, 2003 5:38 pm
Post
by jamrop » Sat May 24, 2003 2:30 pm
Hey
Wonder if anyone can help
I am have done a search page, but i am not sure what code to put to say that if there is no resultts found to put a message saying that, instead of a blank page
My code is:
Code: Select all
<?php
$db =mysql_connect("localhost","ja", "");
mysql_select_db("ja",$db);
$sql = "SELECT * FROM anime where Anime_Name like '%$search%'" ;
$rs=mysql_query($sql,$db);
$numofrows =mysql_num_rows($rs);
?>
<?php
for ($x = 0; $x <$numofrows; $x++)
{
$row = mysql_fetch_array($rs);
if($x % 2)
{
echo "<tr bgcolor="white">\n";
}
else
{
echo "<tr bgcolor ="green">\n";
}
?>
<td bgcolor="#FFFFCC"><font size="-1"><?php echo $rowї'Anime_name']; ?></td>
<td><font size="-1"><?php echo $rowї'Ep_Start']; ?> - <font size="-1"><?php echo $rowї'EP_End']; ?></td>
<td align="center"><font size="-1"><?php echo $rowї'Language']; ?></td>
<td align="center"><font size="-1"><?php echo $rowї'Complete']; ?></td>
<td align="center"><font size="-1"><?php echo $rowї'Discs']; ?></td>
<td align="center"><font size="-1"><?php echo $rowї'Formats']; ?></td>
<td align="center"><font size="-1"><?php echo $rowї'Quality']; ?></td>
<td align="center"><font size="-1"><a href="../list/detail.php?Anime_id=<?php echo $rowї'Anime_id'];?>%20">Info</a></td>
<?php
}
?>
I thought i would do it by putting at the end
Code: Select all
<?php
else
{
echo "Nothing found";
}
?>
but that does not want to work
Many thanks
m3mn0n
PHP Evangelist
Posts: 3548 Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada
Post
by m3mn0n » Sat May 24, 2003 4:11 pm
You should want to use
elseif instead of two
else s' which is not allowed.
http://php.net/elseif
jamrop
Forum Commoner
Posts: 80 Joined: Fri May 16, 2003 5:38 pm
Post
by jamrop » Sun May 25, 2003 5:45 am
i change it around a bit but elseif still does not work
my code
Code: Select all
<?php
$db =mysql_connect("localhost","jam", "");
mysql_select_db("jam_uk_db",$db);
$sql = "SELECT * FROM anime where Anime_Name like '%$search%'" ;
$rs=mysql_query($sql,$db);
$numofrows =mysql_num_rows($rs);
?>
<?php
for ($x = 0; $x <$numofrows; $x++)
{
$row = mysql_fetch_array($rs);
?>
<td bgcolor="#FFFFCC"><font size="-1"><?php echo $row['Anime_name']; ?></td>
<td><font size="-1"><?php echo $row['Ep_Start']; ?> - <font size="-1"><?php echo $row['EP_End']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Language']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Complete']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Discs']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Formats']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Quality']; ?></td>
<td align="center"><font size="-1"><a href="../list/detail.php?Anime_id=<?php echo $row['Anime_id'];?>%20">Info</a></td>
<?php
}
elseif
{
echo "No results";
}
?>
?>
I tried else as well but that did not work
MAny thanks
McGruff
DevNet Master
Posts: 2893 Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland
Post
by McGruff » Sun May 25, 2003 7:54 pm
I didn't properly indent your code but that should be done to make it more readable. Usually I also like to leave a blank line before and after every { or }.
jamrop wrote: i change it around a bit but elseif still does not work
my code
Code: Select all
<?php
IF (something) {
// do this
} ELSE {
//do that
}
$db =mysql_connect("localhost","jam", "");
mysql_select_db("jam_uk_db",$db);
$sql = "SELECT * FROM anime where Anime_Name like '%$search%'" ;
$rs=mysql_query($sql,$db);
$numofrows =mysql_num_rows($rs);
IF ($numrows == 0) {
die('No results. Continue a href link->');
} ELSE {
?>
<?php
for ($x = 0; $x <$numofrows; $x++)
{
$row = mysql_fetch_array($rs);
?>
<td bgcolor="#FFFFCC"><font size="-1"><?php echo $row['Anime_name']; ?></td>
<td><font size="-1"><?php echo $row['Ep_Start']; ?> - <font size="-1"><?php echo $row['EP_End']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Language']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Complete']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Discs']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Formats']; ?></td>
<td align="center"><font size="-1"><?php echo $row['Quality']; ?></td>
<td align="center"><font size="-1"><a href="../list/detail.php?Anime_id=<?php echo $row['Anime_id'];?>%20">Info</a></td>
<?php
}
}
?>
?>
I tried else as well but that did not work
MAny thanks