Menu
Hi, can some1 please tell me why this is bringing up all results and not just where the date in the field ‘new’ is less than or equal to 7 days old.
[code=php]
$new = “SELECT * FROM $selection WHERE New <= DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND Available=’Yes’ ORDER BY Title LIMIT $limitvalue, $user_view_limit”;
cheers adam