$query = mysql_query("SELECT * FROM student");
$number=mysql_num_rows($query);
echo "Total records in Student table= ". $number;
Tim | 05-03-2009 |
The result offered in the main article requires transferring all of the data from the table across the wire to PHP. A much less intensive approach to getting the number of records in a table is: $query = mysql_query("SELECT COUNT(*) FROM student"); list($number) = mysql_fetch_row($query); echo "Total records in Student table=$number"; |
Marcus | 08-04-2009 |
Also, to be less intensive all you need to do is select a single column with the least amount of information such as the primary key column: $query = mysql_query("SELECT key FROM student"); $number = mysql_num_row($query); echo "Total records in Student table=".strval($number) |
JSC | 06-05-2009 |
Looks like the ultimate efficient count would be "SELECT COUNT(key) FROM student" :) |
MSQL | 11-05-2009 |
prefer COUNT(key) AS Total |
arnab | 07-07-2009 |
very useful site. |
konrad | 07-09-2009 |
To Marcus: Little mistake - should be: mysql_num_rows not mysql_num_row |
webmaster | 17-04-2010 |
I used Tim's example. Very helpful. I took me forever to find a decent example. |
Shreeram N Venkatesh | 04-08-2010 |
how could we see the table contents from a database using mysql in the dos prompt? |
lovely | 21-03-2011 |
how to use the fetch_array in select statement? |
DingDong | 16-06-2011 |
Also, COUNT(key) is not the ultimate efficient count. That would be COUNT(*). The first count will require a table scan, but the second will not since it is taken from an already existing cache on the number of rows. |
Akhlas Ahmad | 17-01-2014 |
Thanks. Such useful site. Bookmarked it. |
npinelo | 14-03-2015 |
When I use $query = mysql_query("SELECT * FROM books WERE ves=es"); I get "mysql_num_rows() is not valid MySQL result resource", how can I fix this? |
smo | 15-03-2015 |
Change the query part like this "Select * FROM books WHERE ves='es' " |
bienvenue semakoma | 12-03-2016 |
how can i solve these problems: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /htdocs/functionresult.php on line 5 result(s)found . Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /htdocs/functionresult.php on line 7 |
deepak singh | 18-07-2016 |
how to count user online and offline ? show count? |
Gokul | 05-10-2016 |
consider, mysql_num_rows returns certain number of rows from db, here how to select a perticular one row? |
smo1234 | 07-10-2016 |
mysql_num_rows returns total number of rows , it is not returning rows , so you cant select particular row from it. To get particular row you have to use WHERE condition |