No Rows Returned

[tchallies]

I'm using MYSQL and PHP for a fairly complex review site. Yet something fairly basic is escaping me. I have a very standard SELECT statement

SELECT statement

$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){

I want to do something like:

If 0 rows are returned, then echo

else echo

Can you tell me how I can do this?

[coopster]

mysql_num_rows [php.net] works well for this purpose.

[tchallies]

Can you give me a nudge as to how I'd use it?

[coopster]

Certainly.

$result = mysql_query($sql) or die(mysql_error()); 
if (mysql_num_rows($result) > 0) { 
 while($row = mysql_fetch_array($result)){ 
  // process the results 
 } 
} else { 
 echo 'No rows in result set.'; 
}