total rows in sql table

[Pouncer]

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

$total = <something>;

echo "Total rows: $total";