asgsoft Posted April 25, 2006 Share Posted April 25, 2006 I have been working on this script:[code]<?phpinclude 'config.php';mysql_connect("$host", "$user", "$pass") or die(mysql_error());mysql_select_db("$dbname") or die(mysql_error());function update_sessions(){ $sid = session_id(); if($_SESSION['sitename_online'] == "1") { mysql_query("UPDATE `sessions` SET `time` = '". time() ."' WHERE `sid` = '$sid'") or die(mysql_error()); } else { $_SESSION['sitename_online'] = 1; mysql_query("INSERT INTO `sessions` SET `time` = '". time() ."', `sid` = '$sid'") or die(mysql_error()); }}function get_onlineusers(){ $min = time() - 301; mysql_query("DELETE FROM `sessions` WHERE `time` <= '$min'") or die(mysql_error()); $query = mysql_query("SELECT COUNT(sid) FROM `sessions`"); $num = mysql_fetch_row($query); return($num[0]);}$online_users = get_onlineusers();echo("$online_users");?>[/code] It should say how many unique visitors are online At this moment and it should change every x minuits.It doesn't show anything but 0,What's te problem? Quote Link to comment Share on other sites More sharing options...
sanfly Posted April 25, 2006 Share Posted April 25, 2006 are you executing the first function (update sessions) anywhere? Also at the top of the page are you using session_start(); ? Quote Link to comment Share on other sites More sharing options...
asgsoft Posted April 26, 2006 Author Share Posted April 26, 2006 so what do I need to change? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.