Order by most occuring from a MySQL database

[stovellp]

I have a database with a list of racers in it. I would like to get the top 3 most occuring racers in that list. This is my query:

$sqlQ = "SELECT AnimalName, COUNT(*) FROM racers WHERE 1 GROUP BY AnimalName LIMIT 3";

That gets the count of them, but not in the order of most occuring. I'm not great with MySQL, so could someone please show me what I should be doing to get them in order?

[Pilly]

I use

$sql = "SELECT field1,datestamp, count(*) AS cnt
FROM phplog
WHERE field1 <>'General'
Group by field1
ORDER BY cnt DESC
Limit 10
";

Gives me a top ten... so you can edit this hopefully to your needs.

[stovellp]

Thankyou very much, I got it working thanks to that 🙂 Many thanks