On Wed, 11 Oct 2006, Mark Leith wrote:
> 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.. Actually I'm setting the DATE via drop down menus using PHP and creating the date by hand via variables. NOW() won't work in this instance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
