Toš třeba:
SELECT sloupec,count(`sloupec`) pocet FROM `tabulka` group by sloupec
while($row = mysql_fetch_array($result)){
echo $row[sloupec] .':'.$row[pocet].'<br />';
}
Toš třeba:
SELECT sloupec,count(`sloupec`) pocet FROM `tabulka` group by sloupec
while($row = mysql_fetch_array($result)){
echo $row[sloupec] .':'.$row[pocet].'<br />';
}