Re: how do you fund out if a mysql resource is empty?

[Stuart Dallas <stuart@xxxxxxxx>]

On 13 Jan 2012, at 20:01, Haluk Karamete wrote:

> $result = mysql_query($sql,$link) or die(mysql_error());
> 
> how do you find out if $sql returned any recordsets?
> is there a fast/super efficient  way of finding this out... something
> along the lines of   is_empty($result) type thing?

if (mysql_num_rows($result) > 0) {
  ...
}

http://php.net/mysql_num_rows

And while you're there, have a browse of the function list in the left column.

-Stuart

-- 
Stuart Dallas
3ft9 Ltd
http://3ft9.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php