[SOLVED] mysql ordering by last 30 days

[atticus]

noob question I know  ??? How do I order the following search to return only records processed in the last 30 days?

 

<?php
echo "<h3>Subjects Searched in Last Thirty Days:</h3><center>
<table border=1 style=\"border-collapse:collapse;\">
<tr>
	<th style=\"padding-right:5px;\">Last Name, First Name</th>
	<th style=\"padding-right:5px;text-align:center;\">Processed (yyyy - mo - dy)</th>
</tr>
";
$sql = "SELECT * FROM `order` WHERE cust_id = $id AND processed = 'yes' ORDER BY processeddate DESC, last_name ASC"; 
   $query = mysql_query($sql) or die('Error, query failed : ' . mysql_error());
while($row = mysql_fetch_array($query)) {
echo "<tr>
	<td>".$row['last_name'].", ".$row['first_name']."</td> ";
echo    "<td style=\"text-align:center;\">".$row['processeddate']."</td>
</tr>";		
}	  echo "</table></center>";	  
?>

[pocobueno1388]

Try

 

SELECT * FROM `order` WHERE cust_id = '$id' AND processed = 'yes' AND processeddate < (NOW() - INTERVAL 30 DAY) ORDER BY processeddate DESC, last_name ASC

[revraz]

Depends on how you store your date format.

[rhodesa]

For future reference, check out http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

 

The first example on the page shows how to get records from the past 30 days.

[atticus]

thanks everybody and I appreciate the link...

 

$sql = "SELECT * FROM `order` WHERE cust_id = $id AND processed = 'yes' AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= processeddate ORDER BY processeddate DESC, last_name ASC";