MYSQL record update

[Celina]

i have created a table which include 2 fields (field 1 and field 2) and they are defined as type "timestamp(14)". In my php script, i am going to update field 1 using function now(). However, i find that field 2 also updated at the same time but in the script, i haven't include field 2 in the updat statement.

[siwis]

So post your update sql and somebody may be able to trouble shoot it for you. We can't do much without it 😕

[Lars_Berg]

Timestamp columns are automatically updated when a record is changed. You should rather use datetime as the datatype for the column.

[Celina]

Thanks Lars Berg. 🙂