Page 1 of 1

Search results help

Posted: Sat May 24, 2003 2:30 pm
by jamrop
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

Posted: Sat May 24, 2003 4:11 pm
by m3mn0n
You should want to use elseif instead of two elses' which is not allowed.

http://php.net/elseif

Posted: Sun May 25, 2003 5:45 am
by jamrop
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

Posted: Sun May 25, 2003 7:54 pm
by McGruff
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