The query I am using:
SELECT COUNT(`member_reference`), `email_delivery_hour` FROM
`member_subscriptions` WHERE `list` =1 and `email_delivery_hour` <= 6 GROUP
BY `email_delivery_hour` ORDER BY COUNT(`member_reference`) ASC LIMIT 1
----- Original Message -----
From: "kranthi" <kranthi117@xxxxxxxxx>
To: "Chris" <dmagick@xxxxxxxxx>
Cc: "Ron Piggott" <ron.piggott@xxxxxxxxxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx>
Sent: Monday, August 17, 2009 6:00 AM
Subject: Re: GROUP BY
ASC after GROUP BY ?? didn't mysql throw an error ?
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.392 / Virus Database: 270.13.58/2306 - Release Date: 08/16/09
06:09:00
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
