> > Just a quick comment. The first timestamp field will get updated to the > > current server date and time (make sure it's set correctly) each > > time the record is inserted or updated. The other datatype is datetime > > (not timedate) and will hold the value you enter until specifically changed. > > The second and later timestamps behave like datetime fields and do not change. > > > > Perhaps this will lead you to the solution you seek. > > > > James
> James, I'm a little confused here by what you're referring to here by > "first" and "second" timestamps... A table can be defined with many fields. If there are several fields with the datatype of timestamp, the first one defined has the auto update "feature". The other ones do not. James _____ James D. Keeline http://www.Keeline.com http://www.Keeline.com/articles http://Stratemeyer.org http://www.Keeline.com/TSCollection http://www.ITeachPHP.com -- Free Computer Classes: Linux, PHP, etc. Summer Semester Begins Jun 20 -- New Classes Start Every Few Weeks. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
