Archiving using date.

[virtuexru]

OK. So I have the date set in my database under DATE

 

How would I go about only giving the results for say.. March using this, like how would I specify what date to start at.. should I use

 

while($date > 03-01-07) or something?

 

<?php
$display = "SELECT id, date FROM postlist ORDER BY id DESC LIMIT $offset, $rowsPerPage";
$result  = mysql_query($display) or die(mysql_error());
?>

 

[emehrkay]

i would think you do that in the query using BETWEEN

 

SELECT ... WHERE date_field BETWEEN start AND END ... ORDER ..etc"