[SOLVED] search records in a certain time frame

[moogle1979]

I am trying to make it where records are only searched 90 days back

 

here is the code I am using

 

<?php
$date = date('m/d/y');
$newdate = strtotime ("-6 months");
$query = mysql_query("SELECT * FROM log WHERE updated_user = '" . $result['user'] . "' AND date BETWEEN '$date' AND '$newdate' ORDER BY date") or die(mysql_error());
while($log = mysql_fetch_array($query)){
echo $log['username'] . " edited this account at " . $log['date'] . " for the following reason: " . $log['reason'] . "<br />";
}
?>

 

Despite the code asking for items only 6 months back I seem to get all items

 

Any suggestions on how I can only search for items within a certain time period?

[DarkWater]

SELECT * FROM log WHERE updated_user = 'user' AND date >= SUBDATE(NOW(), INTERVAL 90 DAY);

 

Try something along those lines.