I am trying to show only results for the last week of entries, done by date.
Code: Select all
$today = date("Y-m-d");
$ltwek = strtotime('-1 week');
$mem = "SELECT * FROM tablename WHERE '_dat' BETWEEN $ltwek AND $today";Moderator: General Moderators
Code: Select all
$today = date("Y-m-d");
$ltwek = strtotime('-1 week');
$mem = "SELECT * FROM tablename WHERE '_dat' BETWEEN $ltwek AND $today";Code: Select all
SELECT * FROM tablename WHERE `_dat` BETWEEN 1167754895 AND '2007-01-09'Code: Select all
SELECT * FROM tablename WHERE `_dat` BETWEEN Curdate()-Interval 1 week AND Curdate()Check the manual that corresponds to your MySQL server version for the right syntax to use near 'week AND Curdate()'
Code: Select all
$mem = "SELECT * FROM tablename WHERE `_dat` BETWEEN 'Curdate()-INTERVAL 1 MONTH' AND 'Curdate()'";Code: Select all
SELECT * FROM tablename WHERE `_dat` BETWEEN Curdate()-Interval 7 day AND Curdate()