I want to only display records that are 14 days old or younger.
Is this a correct format ?
$sql = “SELECT * FROM stuff WHERE flag1 =”y” AND ((date(“Y-m-d”)-create_date)<14 days)”;
Thanks for your help.
<i> </i>SELECT * FROM stuff WHERE flag1 ='y' AND DATE_ADD(create_date, INTERVAL 14 DAY) >= CURDATE();
SELECT * FROM stuff WHERE create_date >= DATE_SUB(NOW(), INTERVAL 14 DAYS)
Help @DaveinLondon spread the word by sharing this article on Twitter...