for one, counts is not a colums, it aggreate values. In your case, since you didn't group, all record retrieved will have the same value for count(*), the number of record. So of course you can't order by counts, it's a single value.
On Wednesday 24 October 2001 02:43 am, Carl Troein wrote: > Teddy A Jasin writes: > > Hi, > > I have this mysql statement: > > select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs > > where counts > 10 and datesent between '2001-09-24' and '2001-10-24' and > > (returncode > 0 and returncode < 10) group by hpnumber order by counts > > DESC --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php