count(*) versus mysql_num_rows
Hello!
If I want to know the number of rows of a certain table, what is it better?
=>$table=mysql_query("select * from mytable"); $number_of_rows=mysql_num_rows($table);
or
=>$row=mysql_fetch_array(mysql_query("select count(*) as howmany from mytable")); $number_of_rows=$row["howmany"];
Thank you very much.
Subject
Views
Written By
Posted
count(*) versus mysql_num_rows
28137
November 21, 2005 03:54PM
9099
November 24, 2005 05:55AM
7453
November 24, 2005 09:18AM
8065
June 02, 2006 04:13AM
5617
June 08, 2006 09:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.