mysql: how do I get the rowcount of the results?

[partha]

I want to execute some alternate code if the a query produces zero results, but I can't find any info on the web about how to get the number of rows in a mysql result.

do you know how I can get it?

[StupidScript]

Use mysql_num_rows.

See: [dev.mysql.com...]

i.e.

$getStuff=mysql_query("select * from users");

if (mysql_num_rows($getStuff)<1) {

... no rows returned, so ...

} else {

... rows returned, so ...

}