SELECT name, COUNT(name) FROM `table`
GROUP BY name
;

[php:1:a961e42f88]$test_query = mysql_query("SELECT name, COUNT(*) FROM test GROUP by name");
while ($test = mysql_fetch_array($test_query)){
echo $test[0].': ';
echo $test[1].'<br/>';
}[/php:1:a961e42f88]