Check to see if Results from Query Exist

[holty]

Hi

In my php page I query the database - if there are no results I get a host of errors, however if there are results it prints them fine.

How can I test to see if the query produced no rows so that I can put a friendly message up?

Thanks

[holty]

Sorted

$numrows = mysql_num_rows($result);
if ($numrows == 0) {
echo '<br>'."No data returned";
exit;
}

[phoztech]

just do a simple if statement... to check if there is a result set... then inside that if put all the code that requires that there is a result set.

if($result) {

insert code here that requires that the database had something in it

}

[raf]

phoztech,

checking the number of returned rows with mysql_num_rows is the only option.

$result wil only be False if the query was incorrect, so incorrect sql-syntax. Not if it does not return any records.

http://www.php.net/manual/en/function.mysql-query.php

[phoztech]

sorry.. you are correct... I have only messed around with mysql/php for a few months...