Unless you've used GROUP BY you'll only return one row. I think that
something like
SELECT x, count(y)
FROM table
GROUP BY y
ORDER BY count(y);
Ought to work.
Later,
Sterling
Elias wrote:
> Hello,
>
> I made a query that uses count(*)
> now how can i get the results sorted following the biggest count(*) result?
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]