Filter records

[raouleduke]

I have this script I want to filter the list by anything greater than $rangetime1 and records =1, how do I filter and where do I put it?

$rangetime1 = date("Y-m-d" , (strtotime($todaysdate) - (60*60*24*7)));
	}
	ini_set("MAX_EXECUTION_TIME", "10800");
	$query = "SELECT MAX(CLOSEDATE), CUSTNO, COUNT(*) as records from LUTHERSELLANDRECOMMEND group by CUSTNO"; 
    print $query;
	$result = mysql_query($query); 
    echo '<table style="font-family:verdana,arial,helvetica,sans-serif;font-size:medium;color:#000066">'; 
    while ($row = mysql_fetch_array($result)) { 
    print"
	<tr>
	<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["CUSTNO"]}</font></td>
	<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["records"]}</font></td>
	<td><font color='#000066' size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["MAX(CLOSEDATE)"]}</font></td>
	</tr>";
}

Thanks in advance.

[LordShryku]

Could use it as a HAVING clause in your SQL or you could use it as a conditional before printing.