single query updating two fields???

[RadioGeek]

First, let me describe the two fields in question. They are both on the table "users" and are both TIMESTAMP(14) type fields:

UserDateLastLogin
UserDateLastActivity

Assume that there is a row that corresponds to "UserID = 1" (there is).

Using this query:

UPDATE users SET UserDateLastActivity=NOW() WHERE UserID = 1

This query would presumably set "UserDateLastActivity" to the current timestamp.

However, it sets BOTH fields to NOW(). I didn't tell it to do that...so what on earth is going on here? Your help is greatly appreciated.

[ymir]

The problem is that the timestamp type automatically updates whenever a change in that row takes place or when a new entry is made. The solution is to change your UserDateLastLogin to a datetime field in format 0000-00-00 00:00:00 to capture date and time.