how to do sort / mixing in php

[ggcdc]

i want to know how to do sort using php,

for example,

$table = mysql_query("SE LECT * FROM ... ");

while ($... = mysql_fetch_arr ay($table)

the result will show like this :

data1
data8
data7
data2
data1
data8
data7
data2
data1
data8
data1
data8
data7
data2
data1
data8

but i want to know how to make the result show like this :
data1 (14)
data2 (10)
data7 (5)
data8 (19)

Thanks in advance to all for any info.

[code green]

SELECT datafield, COUNT(datafield) GROUP BY datafield

[ggcdc]

useful reply
thanks code green u really an Expert