if datetime within a year of current time

[webguy262]

I need an if statement that works like this...

 

if the datetime in the database is less than a year earlier than the current date

 

account is good;

 

else

 

your account has expired.

 

I suspect it is something like...

 

if (curtime() - $datetime_in_dbase <= 365 days) {

 

ok

 

} else {

 

not ok }

 

Can't seem to find exactly how to code it.

 

Suggestions?

[rwwd]

You could do what you stated just making sure that the format of date/time matches whats in the DB

 

so:

 

if((date("y m d") - $datetime_in_dbase) <= 365 days){

//good

}else{

//bad

}

 

pseudo code there obviously

 

Rw

[Mchl]

In MySQL

SELECT IF(dateTimeColumn > CURDATE() - INTERVAL 1 YEAR,TRUE,FALSE) AS accountValid FROM ...

[webguy262]

thanks for the replies!

 

I'll try them and post back.