Hello again, I am trying to set up a SQL statement using NOW(), what I am wanting to do is to use NOW() then do a search on any date less than 7 days. Before I get several e-mails asking why. I am trying to a news base database for the company intranet and I am wanting to only show newsitems that are 7 days or less. And I want NOW() to set today date and then go back as far as seven days. But I am not sure now to use < less than in my statement with NOW(), or if it will work.
---------------------------- | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | ---------------------------- BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. "Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself."- Harvey Fierstein --------------------------------------------------------------------- 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