note 26252 added to function.date
| From: | farinspace at rack1 dot php dot net | Date: | Thu, 24 Oct 2002 02:51:02 +0000 |
| Subject: | note 26252 added to function.date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-38486@lists.php.net to get a copy of this message | ||
// with out using PHP / MySQL back and forth, all done in MySQL
// sql statement - delete all records 5 minutes or more old
$sql = 'DELETE FROM chat_lobby WHERE timestamp < FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()) - 300)
+ 0';
--
http://www.php.net/manual/en/function.date.php
http://master.php.net/manage/user-notes.php?action=edit+26252
http://master.php.net/manage/user-notes.php?action=delete+26252
http://master.php.net/manage/user-notes.php?action=reject+26252