[Resolved] Order by count(*) with a group by?

[Kinniken]

Hi, I need to write a request that will group records on a field "AuthorName" and return the number of records for each value of "AuthorName" in descending order of count(*).

The following request works, but does not do the ordering:

SELECT AuthorName,COUNT(*)
FROM quizquestion
GROUP BY AuthorName;

This attempt at ordering gives me an "#1111 - Invalid use of group function" error when testing it in phpMyAdmin:

SELECT AuthorName,COUNT()
FROM quizquestion
GROUP BY AuthorName
ORDER BY COUNT();

Anyone has an idea of an other way to do that?

TIA,

Kinniken

[jayant]

SELECT AuthorName,COUNT(*) as myorderfield
FROM quizquestion
GROUP BY AuthorName
ORDER BY myorderfield;

[Kinniken]

:o It was that simple... I should have guessed.

Well, thanks a lot!