I did the grouping too... "...group by hpnumber" so what could be wrong?
regards, Teddy At 02:13 AM 10/24/2001 -0400, Kodrik wrote: >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 Teddy A Jasin Systems Analyst / Administrator 45B, Circular Road Singapore 049400 Tel: 438 2418 DID: 4386924 Fax: 438 4803 email: [EMAIL PROTECTED] w w w . e f u s i o n . c o m . s g --------------------------------------------------------------------- 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