> I am wanting to do a count in PHP. I want to be able to count the number
> records from a given database and display this count on the page. Can this
> be done using PHP or is the sql thing?

If you're using MySQL - I don't know if COUNT() is a part of SQL'92 - you
can use SELECT COUNT(*) FROM table like this:

echo mysql_result(mysql_query("SELECT COUNT(*) FROM table"),0,0);

The two zeros at the end means that mysql_result is to fetch the first row,
the first column of the result.

(Also, it'll be much faster than mysql_num_rows(mysql_query("SELECT * FROM


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

Reply via email to