khan kaka Posted November 13, 2005 Share Posted November 13, 2005 i am using dreamweaver 8 and php. i want to make a recordset that displays records older then 20 days. i cant work out how to filter the date field. thanks in advance Link to comment https://forums.phpfreaks.com/topic/2856-displaying-records-older-then-20-days/ Share on other sites More sharing options...
Cook Posted November 14, 2005 Share Posted November 14, 2005 SELECT * FROM `mytable` WHERE `mydatefield` > (NOW() - INTERVAL 20 DAY) Link to comment https://forums.phpfreaks.com/topic/2856-displaying-records-older-then-20-days/#findComment-9608 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.