[SOLVED] Checking if the query is empty?

[spiceydog]

I have a simple query echoing a list of things. I want a simple if test to say something special if the query turns up no results but I'm not sure how... does anyone here know how to fix that?

 

[paul2463]

$query = "Blah blah blah"; 
$result = mysql_query($query) or die ("Error in query " . mysql_error());
$rows = mysql_num_rows($result);
if ($rows < 1)
{
echo "Oops no rows returned";
}
else
{
blah blah blah echoing out your data
}

 

hope that helps

[spiceydog]

than you!!!!!