I have a timestamp field which gets updated every time I do an edit to a record.
I use this to sort and display a "latest listings" and do not want old listings to be updated with the NOW() datetime. Is there anyway to leave this field alone on an update using phpMyAdmin?
uhm I believe it IS DATETIME that works like that, at least I know there is some "date/time"-type that updates itself when the record is updated, so simply try another one.