[SOLVED] php/mysql Check if timestamp (2009-11-01 20:05:18) is more than 7 days old

[Jnerocorp]

Hello,

 

Is it possible for php/mysql to check if the timestamp in a row/table is older than 7 days

 

the timestamp looks like this:

2009-11-01 20:05:18

 

in table "tokens"

 

-John

[taquitosensei]

this should do it

 

if($timestamp < date("Y-m-d H:i:s",strtotime("-7 Days"))); 
{

}

[MadTechie]

or MySQL

SELECT *,DATE_ADD(TimeStampField, INTERVAL 7 DAYS) > NOW() as Over7Days FROM tokens
if($row['Over7Days']){
   echo "Over 7 days";
}

[Jnerocorp]

thanks guys

[MadTechie]

Solved ?

if so please click topic solved!