users online query help needed

[phill2003]

i have tried this

$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]

$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 :)