Users Online Display Not Functioning

[CBaZ]

this is my code to showing how many users are online.

I am trying to do this with admin, regulars and guests.

it shows only regular users as of now and doesn't remove them when they sign out. any ideas greatly appreciated.

 

include("dbinfo.php");

 

// Set length of session to twenty minutes

define("SESSION_LENGTH", 20);

 

$sConn = @mysql_connect($dbServer, $dbUser, $dbPass)

or die("Couldnt connect to database");

 

$dbConn = @mysql_select_db($dbName, $sConn)

or die("Couldnt select database $dbName");

 

 

$timeMax = time() - (60* SESSION_LENGTH);

 

$result = mysql_query("select count(*) from usersOnline where unix_timestamp(dateAdded) >= '$timeMax' and permission = '0'");

$usersOnline = mysql_result($result, 0, 0);

 

$resulta = mysql_query("select count(*) from usersOnline where unix_timestamp(dateAdded) >= '$timeMax' and permission = '1'");

$usersOnline2 = mysql_result($resulta, 0, 0);

 

$resultb = mysql_query("select count(*) from usersOnline where unix_timestamp(dateAdded) >= '$timeMax' and username = 'Guest'");

$usersOnline3 = mysql_result($resultb, 0, 0);

 

 

 

$connect = mysql_connect("localhost", "login", "password") or die("Could not connect to database: " . mysql_error());

mysql_select_db("database", $connect) or die("Could not select database");

$result3 = mysql_query("SELECT COUNT(*) AS count FROM users WHERE permission = '0'");

$row = mysql_fetch_array($result3);

 

$result4 = mysql_query("SELECT COUNT(*) AS count FROM users WHERE permission = '1'");

$row2 = mysql_fetch_array($result4);

 

echo "" . ($usersOnline2 != 1 ? "" : "") . " $usersOnline2 Admin" . ($usersOnline2 != 1 ? "s" : "") ." of $row2[count]. ". " </br> ". ($usersOnline3 != 1 ? "" : "") . " $usersOnline3 Guest" . ($usersOnline3 != 1 ? "s" : "") ."." . " </br> " . ($usersOnline != 1 ? "" : "") . " $usersOnline User" . ($usersOnline != 1 ? "s" : "") ." of $row[count]" . ". ";

?>