[RESOLVED] Date Difference

[SeanKann]

I'm trying to do a date difference. I have in my database dates of when info was added. I want to show that info for repairs so that I can put a change the td bg colour to yellow if more then 2 days then red if more then 4 days.

I know how to get the if elseif statement to work I'm just having a hard time figuring out how to do the date differ

my date is in the database like this

date("Y-m-d")

I tried strtodate and google to come out with something but can't figure it out

I know it's most likely something simple.

TIA

[Weedpacket]

You've marked this as resolved. Does that mean you have a resolution (in which case, what was it?), or was it accidental?

[SeanKann]

This is what I did to get it working

$current = date("Y-m-d");
$current1 = strtotime($current);

while($row = mysql_fetch_array($result))
{

$date = $row['date'];
$date1 = strtotime($date);
$yellowdate = floor(($current1-$date1)/86400);
$reddate = floor(($current1-$date1)/86400);
echo "<tr>";
if ($yellowdate < 2) {
echo "<td>" .$row['date']. "</td>";

} elseif ($reddate < 3) {

echo "<td BGCOLOR='yellow'>" .$row['date']. "</td>";

} elseif ($current1 == $current1)
echo "<td bgcolor='orange'>" .$row['date']. "</td>";