Ed Curtis wrote:
> I'm having some trouble setting a future date within a table. I have one
> column 'this_date' which is a DATE field and I'm trying to add 90 days to
> it and set a column named 'future_date', also a DATE field.
>
> I don't know if the problem is that I'm trying to write the value into
> the 'this_date' and 'future_date' fields in the same query.
>
> UPDATE this_table SET
> this_date = $this_date,
> future_date = (DATE_ADD(this_date) INTERVAL 90 DAY)
>
>
> Would this work?
>
> Thanks,
>
> Ed
>
>
>
>
UPDATE this_table SET
this_date = NOW(),
future_date = NOW() + INTERVAL 90 DAY;

This is probably along the lines of what you want..

Cheers,

Mark

--
Mark Leith, Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification