mysql_result and count and group by

[jonniejoejonson]

$sql= "SELECT count(*)

FROM name_table

WHERE name='dave'"

GROUP BY state;

$sql_result=$database_object->query($sql);

$sql_result = mysql_query($sql,$connection)

 

$totalNumberOfRows=mysql_result($sql_result, 0);

 

This works fine as long as there is at least 1 result.. how are you meant to get the result of count if the count reult is 0;

[CodeMaster]

You might want to use mysql_num_rows().