mysql date question

[Charisma Bypass]

I have to get a date, add 30 days to it and then insert that new date into a table...

Gettind the date is easy, it's the date of purchase: $order->info['date']

Adding 30 days, I thought to use the INTERVAL 30 DAY

So, my end code looks like;

("
insert into XYZ (code, amount, date) values ('123', '15', '" . $order->info['date'] . "'
");

The above works fine - it inserts the necessary details.  I can't get the right syntax to add the 30 days onto the date.  Date looks like this: 2009-02-12 22:05:01

Thank You in advance for any help.

[sarahA]

Code:

insert into XYZ (code, amount, date) values ('123', '15', DATE_ADD('" .$order->info['date'] . "', INTERVAL 30 DAY)

should work

[Charisma Bypass]

Thanks Sarah, appreciate that

I ended up using;

'" . $order->info['date'] . "' + interval 30 day