> I made a query that uses count(*)
> now how can i get the results sorted following the biggest count(*)

select count(*) as score from foo group by y order by score desc

may do the trick...

I often have trouble with aggregates not being allowed where I want them or
not being able to aggregate on all records, but only display a subset (or
vice versa).

WARNING [EMAIL PROTECTED] address is an endangered species -- Use
Wanna help me out?  Like Music?  Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm

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]

Reply via email to