I have a table with two timestamp(14) fields called add_date and updated. When I insert a new entry I want the current date/time set into these two fields. When I update the entry I only want the updated field to change. The problem is that everytime I update the entry, both fields' timestamps are changed.
When I do an UPDATE query, I set updated = now()
My settings for both fields are timestamp(14) and fields can be NULL.
Any ideals on what I'm doing wrong?:confused: