graham23s Posted September 22, 2008 Share Posted September 22, 2008 Hi Guys, what i'm trying to do here is run a query to bring me back the rows of products that have been uploaded within 7 days! or 1 week. SELECT * FROM `fcp_products` WHERE `date_added`='' i store the time as: 2008-09-22 15:13:38 i am stuck comletely on this one any help would be great thanks guys Graham Link to comment https://forums.phpfreaks.com/topic/125378-working-out-x-days/ Share on other sites More sharing options...
F1Fan Posted September 22, 2008 Share Posted September 22, 2008 You can use PHP's strtotime("-7 days"), but it looks like you'd be better doing it in your SQL, which should be posted in one of the SQL boards. Link to comment https://forums.phpfreaks.com/topic/125378-working-out-x-days/#findComment-648199 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.