[RESOLVED] How do I grab the rows of a table and echo the quantity?

Wales

How do I grab the number of rows of a table and echo the quantity out?
For example..I have ten users for the table 'user' and I want to say We have a total of 10 users on our site!

laserlight

Typically, something like this will do:

SELECT COUNT(*) FROM user;

Wales

Thanks for the help. Couldn't get that to work, but got a SELECT * to work with mysql_num_rows

laserlight

Couldn't get that to work, but got a SELECT * to work with mysql_num_rows

That is incredibly inefficient, unless you actually want to select everything from all the rows.

If you are using the old MySQL extension, it would be a one-liner:

$num_rows = mysql_result(mysql_query("SELECT COUNT(*) FROM user"), 0);