comparing

[JD_]

ive built a little news system and i want to show older news e.g news.php?month=3 will show the last 3 months news etc..

i cant seem to get the date comparision working though. entry's in the n_date field in the database are in the format of d/m/y

// work out months
$month = date("m");
$year = date("Y");
$day = date("d");

$this_m = date( "d/m/y", mktime(0, 0, 0, $month - 1, 0, $year) ) ;
$three_m = date( "d/m/y", mktime(0, 0, 0, $month - 3, 0, $year) ) ;
$six_m = date( "d/m/y", mktime(0, 0, 0, $month - 6, 0, $year) ) ;
$twelve_m = date( "d/m/y", mktime(0, 0, 0, $month - 12, 0, $year) ) ;

// Month Switch // 
switch ($month) { 

case "1"; $query = "SELECT * FROM News WHERE n_date > $this_m ORDER BY n_date DESC"; // The Query
break;

case "3"; $query = "SELECT * FROM News WHERE n_date > $three_m ORDER BY n_date DESC"; // The Query
break;

case "6"; $query = "SELECT * FROM News WHERE n_date > $six_m ORDER BY n_date DESC"; // The Query
break;

case "12"; $query = "SELECT * FROM News WHERE n_date > $twelve_m ORDER BY n_date DESC"; // The Query
break;

default: $query = "SELECT * FROM News ORDER BY n_date DESC LIMIT 5"; // The Query

}
       $query_result = mysql_query ($query) or die('SQL Query Failed - Getting News');
	   for($i = 0; $i < 100; $i++){ 
       for ($count = 1; $row = mysql_fetch_assoc ($query_result);++$count) {

display results here..

}

[toplay]

I assume since you have the date in m/d/y format that you're not using one of MySQL's date data types and just have it as char or varchar. This comparison you're doing won't work then. It could if you had it YYYYMMDD. But, I recommend that you change your column to use a date format type. That way you can use many of MySQL's built-in date and time functions.

With n_date as a proper date type, you can then do it strictly with MySQL. Examples:

$query = "SELECT * FROM News WHERE n_date >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) ORDER BY n_date DESC";

$query = "SELECT * FROM News WHERE n_date >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH) ORDER BY n_date DESC";

$query = "SELECT * FROM News WHERE n_date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) ORDER BY n_date DESC";

$query = "SELECT * FROM News WHERE n_date >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR) ORDER BY n_date DESC";

See manual page:
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

hth.