Number of results problem

[Cronje]

I'm trying to determine the number of results from a SELECT, but am having trouble. My code:
$query = mysql_query("SELECT * FROM tablename WHERE name='xxx'");
$num = mysql_num_rows($query);

It works fine when 'xxx' is in the table, but when it finds none, 'echo $num;' doesn't display anything.

Help please!

-Cronje

[laserlight]

That's rather strange. You mean that:

$query = mysql_query("SELECT * FROM tablename WHERE name='xxx'");
echo mysql_num_rows($query);

Doesnt print 0?

Anyway, if you only want the count, I suggest doing:

$result = mysql_query("SELECT COUNT(*) FROM tablename WHERE name='xxx'");
echo mysql_result($result, 0);