[RESOLVED] adding stored month value to stored date

[Emarshall]

HI

i have a simple problem where i wish to add a number of months, stores in a database field to another stores value that is a date ( not today).

data base is MySQL and the date is in YYYY-MM-DD format
The month field is simply a variable, interger 2 digits.

I have tried the adddate function in MySQL but it does not seem to take a variable as a interval field.

Is there a simplr PHP way of achiving this??

Please help

[dalecosp]

'Tis a cinch:

<?php

$olddate = "2005-12-13";   // today, for argument's sake...

$n = 2;   // let's add 2 months ....

$newdate = date("Y-m-d",strtotime("$olddate+$n months"));

echo $newdate;
?>

😉