Query returns no results...

[RBB]

Question from a real newbie: I have a number of rows stored in a MySQL database table. Take a look at this short piece of code:

if ($Query) {
print ("<p>No matching results.</p>");
} else {
while ($Row = mysql_fetch_array($Result)) {
print ("$Row[date], $Row[time]. $Row[eventname]. \n"); }
}
mysql_close($Link);

How can I modify the first line of this code so that if the $Query produces no matching results (not zero, but no matching results)? So I want the $Query to read like this:

If $Query IS NULL, Print "no matching results," else print the matching rows from the table.

Does that make sense? THANK YOU for your help.

--Bob

[cgraz]

well if there are no matching results, then wouldn't it return 0 rows? how can it return 1 or more rows if nothing matched the criteria?

if(mysql_num_rows($Query) == '0') {
   echo "No results found";
} else {
   // display results here
}

Cgraz

[RBB]

Your IF statement appears to be doing the trick:

if(mysql_num_rows($Query) == '0')

I'll keep testing it, but for now it looks like it is working properly.

THANK YOU!

--Bob