On 17 Jun 2003 at 14:05, Lucas Heuman wrote: > After I set starttime to now(), anytime I run another update query > against the row starttime changes to a new value.
You don't give the structure of your table, but it appears that you're using a TIMESTAMP column, which has automatic updating by design: http://www.mysql.com/doc/en/DATETIME.html If you don't want automatic updating, perhaps you should use a DATETIME column instead. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]