Code: Select all
CREATE TABLE session_info (
SessionID INT UNSIGNED NOT NULL AUTO_INCREMENT,
Param VARCHAR(255) NOT NULL,
Expiration TIMESTAMP NOT NULL,
PRIMARY KEY (SessionID)
) ENGINE=MYISAM DEFAULT CHARSET=latin1;Code: Select all
$expiration = time() + 7200;
UPDATE session_info SET Expiration = FROM_UNIXTIME($expiration) WHERE SessionID = 5;Code: Select all
select UNIX_TIMESTAMP(Expiration) Expiration from session_info where SessionID = 5;Code: Select all
UPDATE session_info SET Param= 'aaa' WHERE SessionID = 5;Is this how things are suppose to happen?
I thought that the Expiration column shouldn't change.
thanks