joepetrini

If your using mysql 5 you can use a trigger to get fine grain control of record updates. The following will ensure that a timestamp field will not be changed on every update. You could of course use mysql date format in there as well. [code] CREATE TRIGGER test_trg BEFORE UPDATE ON sometable FOR EACH ROW set new.created_at = old.created_at; [/code] Full example: [a href=\"http://www.codedumpster.com/sql/mysql5_timestamps\" target=\"_blank\"]http://www.codedumpster.com/sql/mysql5_timestamps[/a]