[SOLVED] "Default" column set to "CURRENT_TIMESTAMP", but not updating

[ShootingBlanks]

Hello.

 

In phpMyAdmin, I have a row in a table with the following specs:

 

* Field (name): updated

* Type: Timestamp

* Coallition: (empty)

* Attributes: (empty)

* Null: No

* Default: CURRENT_TIMESTAMP

* Extra: (empty)

 

However, anytime I update a record, the "updated" field stays as the creation date of the record (not the current date).  What could I be doing wrong here?  What other information is needed for me to get help on this?  Thanks!!!

 

[revraz]

May want to post in the mysql forums

 

http://www.phpfreaks.com/forums/index.php/board,3.0.html

 

If you suspect your php code, then post that instead so it can be reviewed

[Glyde]

ALTER TABLE table_name MODIFY updated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

[ShootingBlanks]

Thanks! - that worked!!!