Date comparrison issues

[Sonic_Rage]

Ok, I'm really having a problem with this so any help will be greatly appreciated.

Here's the deal, using a date field in the database, I store my dates with the mktime() function.

What I'm trying to do with no luck is getting the script to compare the current time with the date stored in the DB. If the date in the DB is 5 days or less, then it should display the word "New", if older then 5 days, disply nothing.

Here's my code:

         $date = $row['date']; // Get date out of DB
         if ($date >= mktime()-(60*60*24*5))
          {
            echo" <FONT COLOR=red>New Pic!</FONT>";
          }
         else {}

Thanks for your help, and please, don't tell me to use strtodate() or something since I really need to see a working example.

[LordShryku]

I'm confused. Are you storing it in the database as a date(yyyy-mm-dd) or as a timestamp?

[seby]

try this:

$newpic = '';
if (strtotime($row['date']) >= strtotime('5 days ago'))
{
     $newpic = "<font color=\"red\">New Pic</font>";
}

then use $newpic where you want it to display.
it should work if your date is datetime format.

[Sonic_Rage]

Originally posted by LordShryku
I'm confused. Are you storing it in the database as a date(yyyy-mm-dd) or as a timestamp?

Time stamp using mktime(). I just call it date so it's easy to remember.

Seby, I'll try that out. Thanks.

[Sonic_Rage]

Hmmm... no go. Here's what I'm using:

 $newpic = ''; 
 if (strtotime($row['date']) >= strtotime('5 days ago')) 
  { 
     $newpic = "<font color=\"red\">New!</font>"; 
  }
 echo"<P class=link>Title: ".$row[title]." $newpic ";

The date being pulled from the DB is in the mktime() format e.g. 1070751711

Anything else I may be missing? The code makes sense to me, but then again I'm not the brightest ^_-

[LordShryku]

Since it's already a timestamp, you shouldn't need to use strtotime on it. So just using this should work

if ($row['date'] >= strtotime("5 days ago"))

Just a suggestion though: Instead of using mktime, just use time() to generate your timestamp. It requires no parameters to be passed to it, and will just generate the current timestamp...

[Sonic_Rage]

Ah I think I got it. This seems to work:

 $newpic = ''; 
 if ($row['date'] >= strtotime('5 days ago')) 
  { 
     $newpic = "<font color=\"red\">New!</font>"; 
  }
 echo"<P class=link>Title: ".$row[title]." $newpic ";

Thanks for your help Seby & LordShryku

[sglane]

This probably would helpe:

mktime(date('H'), date('i'), date('s'), date('M'), date('d') - 5, date('Y'));

That would return the timestamp for 5 days ago exactly.