[SOLVED] Date plus 3 months

[Canman2005]

Hi all

 

I have a date stored in my db, example would be

 

2008-11-32

 

I output it as

 

print $row['expdate']

 

How can I add 3 months to that date and out put it as YYYY-MM-DD.

 

Everything I try doesnt seem to have any effect.

 

Thanks

 

Ed

[JasonLewis]

Something like this:

 

#SQL:

SELECT DATE_ADD(date, 3 MONTHS) as date 
FROM table 
WHERE something='something'

[Canman2005]

Hi, that seems to cause an error, any other methods I could try?

[JasonLewis]

What's the error? My MySQL isn't too flash. :\

[Canman2005]

It's ok thanks, managed to track down a script via google