Adding months to a php date function

[bobbobbobbob]

I have a page that Im creating and I want to be able to activate profiles for three months and then is deactivated.

echo date('m-d-Y'); 

I use that to get the current date, but how can I add three months to that and then deactivate the 'activated' field in my Mysql database when the time runs out?

Thanks,
zack

[GaryS]

My suggestion would be to store the create date (only), then run a process (perhaps using CRON) to look for entries where create date is greater than three months old.

[ablaye]

What you can do is add the date when a profile was created to your mysql database. You can create a new field in your profile table and assign it to the value of NOW() in your SQL statement that adds a new profile.

Then, you can pull the profile creation date and substract it from the current date to see if 3 months have passed. There are many date difference functions that are written in PHP that you can find here.

[bobbobbobbob]

EDIT:::Thanks a lot abayle, I think I'll try that out.

[GaryS]

Here's one way to get "three months ago" using timestamps:

echo '<p>Current timestamp: '. time();

//three months ago
$past=mktime(0,0,0,date('m')-3,date('d'),date('y'));

echo '<p>Three months ago' . $past;
echo '<p>Three months ago' . date('d-m-Y',$past); 

[Dan Grossman]

As has been said, you can easily do the comparison from the database. It's more efficient than comparing the dates in PHP.

SELECT * FROM table WHERE create_date < date_sub(current_timestamp, interval 3 month)