in reply to DBI mysql question

The timestamp type in MySQL is documented to do exactly what you describe: it gets updated every time one of the elements of the record gets changed.

MySQL docs say:
Automatic updating of the first TIMESTAMP column occurs under any of the following conditions:

(end quote)

If you don't want that behaviour, you should use a DATETIME type, and explicitly set it to now() every time you want it updated. (DATETIME has exactly the same format as timestamp, it just doesn't have the special propperties.)