phpMyAdmin question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
voltrader
Forum Contributor
Posts: 223
Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area

phpMyAdmin question

Post 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?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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...
Syranide
Forum Contributor
Posts: 281
Joined: Fri May 20, 2005 3:16 pm
Location: Sweden

Post 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.
User avatar
voltrader
Forum Contributor
Posts: 223
Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area

Post by voltrader »

Figured it out... default on dropdown is "NOW", but there is an empty space which if selected doesn't update the timestamp.
Post Reply