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]
