Counting num of rows in PHP+ MySQL

Python

How can I find out how many rows there are in a MySQL table in PHP?

I know that it could be done by using a while statement and then just incrementing a variable on each loop round... but is there a better way?

Forge

of course there is. $rows = mysql_num_rows($result);

$result variable is just the mysql_query() thing, change it your your normal variable.

Python

aha. ok thanks