users online query help needed

[phill2003]

i have tried this

PHP Code:

$regmembers=$DB_site->query_first('SELECT DISTINCT COUNT(userid) AS membersonline FROM session WHERE userid>0 AND session.lastactivity>');
    while($members = mysql_fetch_array($regmembers)) {
        $regmemberson = number_format($members['membersonline']); 


but it doesnt work can anybody help please..

[filburt1]

How doesn't it work...?

[Xenon]

it's obvious why it dosen't work.

$regmembers is a normall array which is the result of the query-first command.

mysql_fetch_array instead needs a mysql result, not an array

[phill2003]

well i tried to put it into that signature hack thats on here, but when i do i get an error..

Parse error: parse error, unexpected $ in /usr/local/psa/home/vhosts/Talkshopforums.co.uk/httpdocs/board/signature.php on line 73

but that bit is the line after the ?>

[phill2003]

PHP Code:

$loggedins=$DB_site->query_first('SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity');
$numberguest=number_format($loggedins['sessions']); 


will this one work do you think

[Xenon]

yes, this will work

[phill2003]

thanks