What is the proper query for slect all from the past number of days. i.e. I would like to return all articles from the past week. Right now I am using SELECT blah, bla FROM table WHERE pubDate BETWEEN CURDATE() - 7 AND CURDATE() AND whatever = 'whatever'
This worked fine until today. the first of month. Thanks much, olinux __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com --------------------------------------------------------------------- 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
