[SOLVED] How do you find out how many rows are in a table?

[ballhogjoni]

How can you tell(using php) how many rows are in a database table.

[chigley]

<?php

$query = mysql_query("SELECT * FROM table") or die(mysql_error());
$rows = mysql_num_rows($query);

echo "There are {$rows} rows in the table!";

?>