getting mysql data between two dates

[tjverge]

Hi,

 

I'm trying to get the records that are between two dates to show on my screen, right now nothing comes up my code I'm using is below

 

$today = date('Y-m-d');
$lastweek = date('Y-m-d',strtotime('-7 days'));
$sql = "SELECT * from `memos` WHERE `date` BETWEEN '$today' AND '$lastweek' AND `delete` !='1'";
$result = mysql_query($sql);
echo "<ol>";
while ($row = mysql_fetch_array($result)) {
echo "<li>".$row['memo']."</li>" ;
}
echo "</ol>";

[tjverge]

fixed it if anyone wants to know you need to reverse the $today and $lastweek in the $sql