[RESOLVED] MySQL TIMESTAMP

[spiritssight]

Hi,

how do you get this field to put the date, time of the transaction into this field, do you use MySQL or PHP to do this, and if so can someone give me a example.

Thanks ahead of time!

Sincerely,
Christopher

[bradgrafelman]

As you'll note from the MySQL manual page entitled TIMESTAMP Properties, "the TIMESTAMP data type offers automatic initialization and updating."

There are column definition examples a bit further down that show how to make MySQL automatically fill/update this column's value.

[spiritssight]

Thanks very much, I thought I had it set up right but I guess I didn't

:-)

Thanks again,
Christopher