Ed Curtis wrote:
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.
UPDATE this_table SET
this_date = '$this_date',
future_date = '$this_date' + INTERVAL 90 DAY;
Same thing still applies really.. And quote your dates...
Cheers,
Mark
--
Mark Leith, Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
