Displaying how many rows in a table

[marc_2ky]

Hi, i have been racking my brains on how to display how many rows are within a table.

I have done something similar in the past but I can't remember how.

If you know how to do this please let me know.

Thanks
Marc

[marc_2ky]

sorry, forgot to mention, say there is 10 rows, do i need to use a print command to display this within a php page?

Thanks again
Marc

[spikeZ]

after your query use

$row_count = mysql_num_rows($query);
#where $query is your query!
echo $row_count; 

[marc_2ky]

would the query be the table name i want to show?

[spikeZ]

No this would appear after your query...

$query = mysql_query("select * from mytable");
$row_count = mysql_num_rows($query); 

[marc_2ky]

duh! am such a tool.

Thanks for your help spikez!

[launchcode]

Rather than select back all of the data if you all you want is a total you can do it like this:

$result = mysql_query("SELECT COUNT(*) AS total FROM tablename");
$total = mysql_result($result, 0, 'total'); 

spikeZ method does of course work too! But if you have a lot of data in your table it'll take a while to select and return it all when you don't really need to.

Cheers,

Rich

[marc_2ky]

Thanks Rich, will try this method too.

Marc

[spikeZ]

Very true Rich but if you are already doing the query, eg

$query = mysql_query("select id, name from table_names where id='3' AND name='Dave'"); 

Using mysql_num_rows gives you that total instead of doing another query....
Just another way of doing it!

S

[launchcode]

Absolutely - there was just no indication he was already doing a query num_rows is fine but it doesn't return how many rows are in his table, only that which was actually selected, which can be quite a different thing! (I know you know this anyway, just making it clear for the OP).