Your sql has more error.

I´ll put the right way below.

UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD($this_date, INTERVAL 90 DAY)

It´ll works fine.


""João Cândido de Souza Neto"" <joao@curitibaonline.com.br> escreveu na
mensagem news:20061011154757.886.qmail@lists.mysql.com...
> Why you don´t try this?
>
>
> UPDATE this_table SET
> this_date = $this_date,
> future_date = (DATE_ADD($this_date) INTERVAL 90 DAY)
>
>
> "Ed Curtis" <ed@homes2see.com> escreveu na mensagem
> news:Pine.LNX.4.44.0610111201370.18226-100000@debian.homes2see.com...
>>
>> 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
>>
>>
>
>