What am I doing wrong here?

[Xenon]

in index.php there was used a joined query..

it's also possible but slows down the query a bit.

in that case it would look like that:

PHP Code:

$adminonline = mysql_fetch_array(mysql_query("SELECT COUNT(userid) as total FROM session LEFT JOIN user USING(userid) WHERE user.usergroupid=6"));

    if ($adminonline['total'] > 1) {
        echo("admin is online($adminonline[total])");
    } else {
        echo("admin is not online!");
    }