Page 1 of 1

Updating a Row without Updating anything ? (Timestamp)

Posted: Wed Dec 08, 2004 1:37 pm
by asterinex
Hello,

I have a Table with online Users . Containing only 2 fields, a username and a timestamp.

Is it possible to Update a record without actually updating anything, because there are no fields to update. The timstamp field will reset to current time wenn updatet


UPDATE usersonline WHERE username = $username ; ?

Thanks in advance!

Posted: Wed Dec 08, 2004 1:58 pm
by kettle_drum

Code: Select all

UPDATE usersonline SET time = NOW() WHERE username = '$username'