[Resolved] Number of records in a mySQL table

[shawnmk]

Is there a simple command for returning the number of records (rows) in a mySQL table? Basically to say there are ### items in the db.

Also, related, to say there are ### where [fieldname] == 0?

I looked through the mySQL docs and couldn't find anything. Any help would be appreciated.

Thanks!

[shawnmk]

ok, I found the COUNT statement, however I'm not sure how to use the output.

Here's my code (I just guessed at how it might work):

<?php

$query="SELECT COUNT(*) FROM [table_name]";
$result=mysql_query($query);

$num=mysql_numrows($result);

$i=0;
while ($i < $num) {
$Total=mysql_result($result,$i,"COUNT");

++$i;
}

echo "There are currently $Total cars in the database.";

?>

[shawnmk]

I apologize for wasting your time with this...more research uncovered the answer. In case anyone else is curious how it is done...

$Total = mysql_result(mysql_query("SELECT COUNT(id) FROM yourtable"),0);

This seems to be the fastest, easiest way to do it if you aren't accessing the db for anything else. If so, mysql_num_rows would probably be better.