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" <kranthi...@gmail.com>
To: "Chris" <dmag...@gmail.com>
Cc: "Ron Piggott" <ron.pigg...@actsministries.org>; <php-db@lists.php.net>
Sent: Monday, August 17, 2009 6:00 AM
Subject: Re: [PHP-DB] 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

Reply via email to