Date - Adding months

[jawbreaker]

I have a date stored in a MySQL table that I need to add a number of months to stored in another MySQL table. The date is stored in the date format in one of my tables: YYYY-MM-DD. How do I add the month to this date using PHP?

[ober]

Use the mktime() function.

[jawbreaker]

How would I use the mktime() function using two variables?

$Date = 2006-01-01
$MonthsToAdd = 6

[arifsor]

[!--quoteo(post=366577:date=Apr 19 2006, 02:45 PM:name=jawbreaker)--][div class=\'quotetop\']QUOTE(jawbreaker @ Apr 19 2006, 02:45 PM) [snapback]366577[/snapback][/div][div class=\'quotemain\'][!--quotec--]
How would I use the mktime() function using two variables?

$Date = 2006-01-01
$MonthsToAdd = 6
[/quote]
instead of using php mktime. you can use ADD_MONTH function of mysql . i dont remember the proper function name but i have done it before.

[Barand]

... or

[code]$Date = '2006-01-01';
$MonthsToAdd = 6;

echo date ('Y-m-d', strtotime("+$MonthsToAdd months $Date"));[/code]