On MySQL anyway, the timestamp is by-design, a update/insert timestamp. I quote:
The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. I suppose if you really wanted to, you could create another timestamp column, and this one would not be automatically updated. On Thu, 2004-03-18 at 10:17, Brian Dunning wrote: > I have a timestamp field that updates itself with NOW() every time I > update the record. I don't want that to happen - I want it to remain as > the original creation timestamp. How do I prevent this from happening? > > Thanks, > > - Brian -- Adam Voigt [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
