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"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] >> >> 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 >> >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
