MYSQL Timestamp Field- Help please

[tony_l]

I have a table that has profiles in it. I read the manuals and they say that if you have the TIMESTAMP field in a table it will automatically insert the current date and time when that particular record is updated or something is inserted into the record.

My problem is that it is not doing that. When the record is created, it looks like a date/time without the dashes, for example-

20020512104428 which looks like-

2002-05-12 10:44:28

AND

It does not change the timestamp when the file is updated, it is still showing the creation date and time.

I have another problem as well with the date functions in MySQL, but i will post that one later, since this is the more important issue to me right now.

Thanks for any help you can give.

[tony_l]

I tweaked it until it worked guys, sorry. I had two timestamp columns in the same table and it only updated the first one. I forgot I had that first column.