Want to find out total number of results returning from mysql.

Question

I want to know how many results have been fetched from mysql through my query...

Answer 1

This is done by calling mysql_num_rows on a mysql result resource:

$result = mysql_query("SELECT id, name FROM users");
print mysql_num_rows($result) . " records";