RE: [PHP-DB] subdate

> please note the time "intervals" that are working. what i > want is to select only data that is two weeks old or younger. i did a > test with one day and it worked great. i inserted the two-week/14days > and neither of them worked. 1 month worked. i could not find anything > on php.net that directed me to this. thank you again, addison > > this works:(*note end of syntax "interval 1 day") > createdate >=subdate(now(), interval 1 day)"); > this does not: (*note end of syntax "interval 14 days") > createdate >=subdate(now(), interval 14 days)"); > this does not: (*note end of syntax "interval 2 weeks") > createdate >=subdate(now(), interval 2 weeks)"); > this works: (*note end of syntax "interval 1 month") > createdate >=subdate(now(), interval 1 month)"); Take a look at http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Date_and_time_functions and see why DAYS and WEEKS is causing you trouble. You're still not checking mysql_error() when you issue a query, are you? Otherwise you may have figured it out already. And, you're still using mysql_db_query(), which is depreciated. :( ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/