כמה מחוברים עכשיו באתר?

CREATE TABLE `online` (
`ip` VARCHAR( 15 ) NOT NULL ,
`time` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY ( `ip` )
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `userstable` ADD `time` TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

$ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
mysql_query("INSERT INTO `online` (`ip`,`time`) VALUES ('$ip',CURRENT_TIMESTAMP)
ON DUPLICATE KEY UPDATE `time` = CURRENT_TIMESTAMP");

$user = mysql_real_escape_string(...);
mysql_query("UPDATE `userstable` SET `online` = CURRENT_TIMESTAMP
WHERE `user`='$user'");

$query = mysql_query("SELECT COUNT(*) FROM `online`
WHERE `time` > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 MINUTE)");
$online = mysql_result($query, 0, 0);