moogle1979 Posted January 4, 2009 Share Posted January 4, 2009 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? Quote Link to comment Share on other sites More sharing options...
DarkWater Posted January 4, 2009 Share Posted January 4, 2009 SELECT * FROM log WHERE updated_user = 'user' AND date >= SUBDATE(NOW(), INTERVAL 90 DAY); Try something along those lines. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.