Amount of results

[Anon]

How do you get the number of results from a mysql_query.

E.g. if you do mysql_query(SELECT * FROM THING)
and there are 5 rows in thing.

how do you get 5 without doing a while with an $amount = $amount + 1;

???

It's probibly dead simple.

[[deleted]]

Indeed it is, if you read the manual :-)

$result = mysql_query($sql, $connection);
echo mysql_num_rows($result);