Page 1 of 1

phpMyAdmin question

Posted: Fri Jun 10, 2005 1:46 am
by voltrader
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?

Posted: Fri Jun 10, 2005 4:24 am
by timvw
Read the manual, because it differs from version to version... But if i'm not mistaken changing to DATETIME type should do the trick...

Posted: Fri Jun 10, 2005 5:04 am
by Syranide
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.

Posted: Fri Jun 10, 2005 1:46 pm
by voltrader
Figured it out... default on dropdown is "NOW", but there is an empty space which if selected doesn't update the timestamp.