MySQL - Checking for no rows returned

[Anon]

Everyone :

I'd like to check if anything is returned from a mysql_fetch_array. I'm doing the following:

$result = mysql_query(<some query>);
$aSchedule = mysql_fetch_array($result);

if (mysql_num_rows($result) <= 0) {
<Do something with data.>

} else {
<Tell user nothing exist.>

}

My question is the above correct or is there a better/easier way to do the above.

Sincerely,
Dale Williams

[Anon]

Check out the get started pages here for database help.

You're pretty much right though - you should always check for numrows before running fetch_array

[Anon]

Except for you have it backwards you are saying if the number of rows ius less than or equal to user then process the data, if your clause returns true then there is no data to process you need to try
if (mysql_num_rows($result) > 0) {
Do something
}
else {
No results
}