I use a timestamp field to track when a row was added to a table. Problem is if I update that row at a later time the timestamp is changed as well. I want to the timestamp to remain set to the time when the row was actually added not updated. Is this possible?
I figured it out. In MySQL version newer than 4.1.2 you can set timestamps to only change when created but with older version you can't. So I have to change my timestamp field to be a datetime field and insert the date and time manually.
Don't use timestamp type field. Use integer type and populate with unix timestamp. php: time() function gives unix epoch time http://us2.php.net/manual/en/function.time.php