counting rows

[buducom]

I have been programming the whole night and now i am all drained out! :-)

i have simple question but i dont remember.

if i have a DB field which contains the following data

10
10
10
10
14
14
14
12
12

I want to count the distinct numbers and order the result by the amount of distinct numbers.

so it should be ordered like

2 and return 10
3 and return 14
4 and return 12

i hope you understand what i mean.

[drawmack]

select count(<field>) from <table> group by <field>

[seby]

that will count all rows, not distinct rows.
you have to do a distinct then a mysql_num_rows on the results.

[drawmack]

Seby,
he doesn't want distinct rows he wants distinct numbers, i.e. all occurances of 10 which is what the group by takes care of.