tellen per naam, hoe?

$query1 = mysql_query("SELECT name,COUNT(name) FROM zomplog_comments GROUP BY name");
$numrows = mysql_num_rows ($query1);
while ($myrow = mysql_fetch_array ($query1)) {
$name = $myrow["name"];
echo $name."<br>";
}

$query1 = mysql_query("SELECT name,COUNT(name) FROM zomplog_comments GROUP BY name");
$numrows = mysql_num_rows ($query1);
while ($myrow = mysql_fetch_array ($query1)) {
$name = $myrow["name"];
echo $name."<br>";
}

$query1 = mysql_query("SELECT name, COUNT(name) AS aantal FROM zomplog_comments GROUP BY name ORDER BY aantal DESC");
$numrows = mysql_num_rows($query1);
while ($myrow = mysql_fetch_assoc($query1)) {
  echo $myrow['name'].", ".$myrow['aantal']."<br />";
}

$query1 = mysql_query("SELECT name, COUNT(name) AS aantal FROM zomplog_comments GROUP BY name ORDER BY aantal DESC");
$numrows = mysql_num_rows($query1);
while ($myrow = mysql_fetch_assoc($query1)) {
  echo $myrow['name'].", ".$myrow['aantal']."<br />";
}