[SOLVED] get records from only 30 days back

[DrTrans]

I need some help .. Basically i only want it to get records dated within the last 30 days

 

$query = "SELECT * FROM applicant ORDER BY AppliedDate  DESC";
        $result = mysql_query($query);
        while($row = mysql_fetch_assoc($result))
	{
	    $applicantid = $row['Applicant_ID'];
	    $applicantdate = $row['AppliedDate'];
	    list($adate,$time) = split( " ", $applicantdate, 2 );
		$applicantfname = $row['FirstName'];
	    $applicantlname = $row['LastName'];

print"<option value=\"$applicantid\">$applicantlname, $applicantfname [ $adate ]</option>";			

}
[code]

This im sure is a simple fix. 

Thanks

[deansatch]

Assuiming date is a time() timestamp format

 

$thirty_days_ago =  mktime(0,0,0,date("m"),date("d")-30,date("Y"));
$query = "SELECT * FROM applicant WHERE AppliedDate >= $thirty_days_ago ORDER BY AppliedDate  DESC";

[DrTrans]

$applicantdate = 2008-07-18 00:00:00 <-- example

 

Thanks

[Maq]

You can do it all in MySQL:

 

SELECT * FROM applicant WHERE AppliedDate >= DATE_SUB(NOW(), INTERVAL 30 day) ORDER BY AppliedDate DESC;

[deansatch]

I made a bad assumption. Doh!