[Resolved] IF AND statement with strtotime function

[Sonic_Rage]

I'm trying to display notes with a certain color based on the date. If the event is today, the color is red, if the event is yesterday and beyond, it's grey, and if it has not happened yet, it remains black. The date is stored as a mktime format in the db.

Here is my code for displaying the notes:

   $date = $row["date"];
   $notes = $row["notes"];
   $current_date = time();

if($date < $current_date) { // If event happened yesterday or later, color is grey
   echo"<P class=fade>$notes\n";
}
 else if($date == $current_date) { // If the event is today, color is red
   echo"<P class=today>$notes\n";
 }
   else { // Event hasn't happened yet, color remains black
     echo"<P class=small>$notes\n";
   }

I can't seem to get today's date to show in red, it shows in grey. What am I doing wrong?

[eoghain]

[man]time/man returns you a unix timestamp which includes the number of seconds since the Epoch (Jan 1st 1970). This means that unless your time in the database matches this value down to the second you will never see red.

What you want to do is convert both of these timestamps into date values then back to timestamps, basically stripping the seconds (really setting them to be the midnight on the day):

   $date = mktime(0,0,0 date("m", $row["date"]), date("d", $row["date"]), date("Y", $row["date"])); 
   $notes = $row["notes"]; 
   $current_date = mktime(0,0,0 date("m"), date("d"), date("Y")); 

   /* Rest of code remains unchanged */

[Sonic_Rage]

Thank you! I got a parse error at first, but then I added a comma after the last 0 in both of the mktime statement and it worked fine.

Thank you for the help and very fast response 🙂

[Weedpacket]

Rather than half a dozen calls to date(), you might want to try

$date = strtotime('00:00', $row['notes']);
$current_date = strtotime('00:00');

"00:00" of course indicates midnight ("midnight" itself isn't accepted, worse luck).