What is a tried and true way to count the number of rows returned by the PHP function mysql_query?

Question

I know about mysql_num_rows ( resource $result ), but I read somewhere that this is not 100% accurate. I saw other alternatives that actually get each line and start the counter, but that sounds pretty inefficient. I am interested to know what others are doing to get an accurate and effective score.

Answer 1

Use mysql_num_rows()when you have completed the request SELECT, or SHOW, and mysql_affected_rows()in the case of queries INSERT, UPDATE, REPLACE or DELETE.
both are pretty accurate!

Answer 2

mysql_num_rows() , mysql_unbuffered_query().

mysql_query(), mysql_num_rows() .

mysql_unbuffered_query(), mysql_num_rows() , .

Answer 3

, , .

. - COUNT WHERE . . , 1000 , 10 .

, , . , , .