Compare Dates

[honkmaster]

Hi, Any help would be great

I have the following code which is looking at two dates, due date and today.

<?php[/font][/color][color=#232323][font='Helvetica Neue']
date_default_timezone_set('Europe/London');[/font][/color][color=#232323][font='Helvetica Neue']
$now = time();[/font][/color][color=#232323][font='Helvetica Neue']

if ($row_rsReleaseQue['duedate'] < date('d-m-Y',$now)) {
   echo '<tr class="tableBody3">';
} else {
   echo '<tr class="tableBody1">';
}
?>

I want to change the background colour of the line in my table based on the due date.

< less that todays date = Red (tableBody3)

== equal to today = Orange (tableBody2)

> greater than today = Green (tableBody1)

Cheers Chris

[Zane]

Assuming this script is working already, all you need is an else if

 

if ($row_rsReleaseQue['duedate'] < date('d-m-Y',$now)) {
	echo '<tr class="tableBody3">';
} else if($row_rsReleaseQue['duedate'] == date('d-m-Y',$now)) {
	echo '<tr....';
} else {
	echo '<tr class="tableBody1">';
}

Edited September 30, 2012 by Zane

[honkmaster]

Thanks for help, I get a syntax error on all echo lines?

 

Cheers Chris

[Barand]

Erm, "d-m-Y" format is useless for > or < date comparisons. Needs to be Y-m-d