Quoting Tony Green <[EMAIL PROTECTED]>:
> > 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. > > Automatic updating of the first TIMESTAMP column occurs under any of > the > following conditions: > > * The column is not specified explicitly in an INSERT or LOAD > DATA > INFILE statement. > * The column is not specified explicitly in an UPDATE statement > and some other column changes value. (Note that an UPDATE that > sets a column to the value it already has will not cause the > TIMESTAMP column to be updated, because if you set a column to > its current value, MySQL ignores the update for efficiency.) > * You explicitly set the TIMESTAMP column to NULL. > > > http://www.mysql.com/doc/en/DATETIME.html > > Hopefully this should help in your quest. Ahuh, and I've read it along with many other pages from /doc/en/ As I said, still having problems. Might just drop this field, and figure it out another time. At the end of the day I am just writing something to learn from. Since I've wanted to do some more mysql/php mucking about. Cheers -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
