TalkPHP - View Single Post - 5 Useful MySQL Functions And Control Flows

Tanax · 11-30-2007, 11:04 PM

I found everything written in this thread useful :D

Anyhow, you should also write something about this:

Code:

DATE_SUB(NOW(), INTERVAL 15 MINUTE)

Because my experience with it is very nice. For example, when you're using a usersystem, and want to have automatic logouts for everyone who hasn't done anything for 15 minutes.

php Code:

UPDATE
        `$this->db->table['users']`
SET
        `$this->db->col['user_session']` = ''
WHERE
        DATE_SUB(NOW(), INTERVAL 15 MINUTE) > `$this->db->col['user_last_action']`;

11-30-2007, 11:04 PM	#8 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	I found everything written in this thread useful :D Anyhow, you should also write something about this: Code: DATE_SUB(NOW(), INTERVAL 15 MINUTE) Because my experience with it is very nice. For example, when you're using a usersystem, and want to have automatic logouts for everyone who hasn't done anything for 15 minutes. php Code: UPDATE `$this->db->table['users']` SET `$this->db->col['user_session']` = '' WHERE DATE_SUB(NOW(), INTERVAL 15 MINUTE) > `$this->db->col['user_last_action']`;