How do you count the number of records in a database?

[meeble]

How do you count the number of records in a database?

If you have:

$db = mysql_connect("localhost","foot","blah"

mysql_select_db("foot",$db);

$result = mysql_query("SELECT * FROM cat",$db);

I tried using count myrow but this doesn't work.


Cheers

James

 

[sleipnir214]

You could try

SELECT COUNT(*) AS the_count FROM cat

or

SHOW TABLE STATUS LIKE 'cat'

Each query will return a set of columns. In the first, the only column returned, "the_count", will contain the row count.

In the second, the column "Rows" will contain the number of rows in the table.

For more information on SHOW TABLE STATUS:

http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[danielhozac]

[tt]mysql_num_rows($result)[/tt] should work too.

http://www.php.net/manual/en/function.mysql-num-rows.php

//Daniel

 

[deecee]

or the more traditional method

1, 2, 3, 4, 5...etc

you get the point
sleep is good