Compare dates, then do a task

[hatmaster]

Here's my challenge:

I am trying to build a PHP query within a loop that compares a date in a row (i.e. row${PaidDate}) with today's date, then displays an image based on whether this paid date is later than today or not.

Here's the logic I think I need to follow, but I don't know enough PHP to make it happen:

---

Get row date (I'll call it "PaidDate")
Get today's date
Compare dates
If today's date is earlier than PaidDate, then display image1

else

display image2

---

That's all. If anyone can help, I sure would appreciate it!!! Thank you!

hatmaster

BTW: I'm using PHP 4.3.6 and mySQL 4.0.17

[devinemke]

$result = mysql_query('SELECT UNIX_TIMESTAMP(PaidDate) AS PaidDate FROM table');
$time = time();
while ($row = mysql_fetch_assoc($result))
{
	if ($time < $row['PaidDate']) {$image = 'image1.gif';}
	else {$image = 'image2.gif';}

echo '<img src="' . $image . '"><br>';
}

[hatmaster]

After several hours of testing and experimenting, I came up with my own solution on the output part of the code:

/ Begin code /

$payday = date($row{'PaidDate'});
$today = date("Y-m-d");

if ($payday > $today)
{
print "<img src='images/image1.gif'>";
}
else
{
print "<img src='images/image2.gif''>";
}

/ End code /

However, I think your code is the better solution. I'm very grateful for your help!!!

Highest regards!!!

hatmaster 😃