/ Published in: MySQL
URL: http://www.sitepoint.com/forums/showpost.php?p=3602847&postcount=2
if you want to get info from a column within certain date, like the latest 7 days, you should use this, mydatefld is your date column
Expand |
Embed | Plain Text
WHERE mydatefld >= DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)
Comments
Subscribe to comments
You need to login to post a comment.

that's not PHP it's MySQL.