Ordering Count results

[Anon]

I am lost on this! What this should output is a top ten list of votes. The most votes to hold the top position and numbered 1 and then display the number of votes this event has. As I have it, I print all the info I want except I am ordering by alphabetical event name instead of ranking in votes.
How can I order the results by vote totals?

mysql_connect(\'localhost\',\'name\',\'pass\') or die (\"Problem connecting to DataBase\");
$query = \"SELECT event, COUNT(*) AS tc FROM Top_Ten_Greatest GROUP BY event LIMIT 10\";
$result = mysql_db_query(\'db_name\', $query);

TIA,
Jim

[Anon]

add a ORDER BY statement after your GROUP BY statement.

ORDER BY 2 DESC

(this orders your results by the second item in your SELECT, the count(*), and orders it descending, high to low value)

[Anon]

WOW works like a charm, I tried naming that second item, but not that way. Thank you very much!
Jim