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 Quote Link to comment 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) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.