Small MySQL Q

[Chronicle]

Hi,
I have a DB with many of the same word in a field, and to list them all (all the words, not every single entry of the words) i am using
$query = "select DISTINCT towncity from table";

However i want to list it by the ones that are most popular - ie list the towncity with the most rows that have that towncity first. If that makes sense?
If anyone could help that would be great. Order by doesn't seem to work...
Thanks

 

[marc2003]

$query =  "SELECT COUNT(towncity), towncity FROM table GROUP BY towncity ORDER BY COUNT(towncity) DESC";

i think that should work.

 

[Chronicle]

Thanks, i'll give it a go now