If no rows are found

[rvdb86]

Hey hope some one can help me out...

 

I have the following sql query to get rows from a table:

 

$sql5="SELECT * FROM products WHERE products_id='$products_id'";
	$result5=mysql_query($sql5) or die(mysql_error());


while ($row5 = mysql_fetch_array($result5))
{
extract($row5);

 

i want to echo a message if no rows are found... can anyone give me any suggestions, i would really apprecaite any help!

[cooldude832]

you should alwasy check for no rows on a select like this

<?php
$sql5="SELECT * FROM products WHERE products_id='$products_id'";
	$result5=mysql_query($sql5) or die(mysql_error());
if(mysql_num_rows($result5)>0){

while ($row5 = mysql_fetch_array($result5))
{
extract($row5);
}
else{
echo "No Results Found.";
}

[Orio]

Before the loop:

 

<?php

if(mysql_num_rows($result5) == 0)
{
//No results
}

?>

 

Orio.