[sde]

mysql has functions for that.

$result = mysql_query("select count(*) from my_table");
$number_of_results = mysql_result($result, 0, 0);