Hi all, Having a slight problem with mysql select query right here. I've learnt that if I were to select a particular data within the last 30 days, this is what my select query should be like:
SELECT something FROM tablename WHERE TO_DAYS(NOW(()_TO_DAYS(date_column)<=30; (This query selects all records with a 'date_column' value within the last 30 days.) Now my question is: What if I would like to display data for the CURRENT MONTH and the last 11 months???(May also said to be the LAST MONTHS) HOw should my select query be like?? Hope to receive some help soon. Any help given is greatly appreciated. Regards, Irin. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php