Date/Time dependant actions

[Omzy]

I have a datetime field in my database, I retrieve this in my script follows:

 

 
$date=$row['date'];
$status=$row['status'];
echo $date; //outputs 2010-01-04 12:20:33
echo $status; //outputs 002

 

I now want to add an IF statement in my script that checks $date as follows:

 

If today's date is 2 DAYS AFTER $date then set $status to 001. The check must also take in to account the time.

[cags]

You should be able to do it with the strtotime function.

 

if(time() >=  strtottime($row['date']. " +2 days")) {
   echo "More than 2 days";
}

If you only need items from the database where the day is more than 2 days ago though you would be better off using MySQL's date functions in the WHERE clause.