total rows in sql table

i need a way of getting the total number of rows in a table

$total = <something>;

echo "Total rows: $total";

This page shows you how to achieve what you want.

http://ca.php.net/mysql_num_rows


HTH