query("SELECT anope_userstats_chan.channel, count(nickid) as nbuser FROM `anope_userstats_ison` inner join anope_userstats_chan on anope_userstats_chan. chanid=anope_userstats_ison.chanid inner join knacki_official ON knacki_official.channel = anope_userstats_chan.channel group by anope_userstats_chan.chanid order by channel"); $userCountPerChan->setFetchMode(PDO::FETCH_OBJ); while ($i = $userCountPerChan->fetch()) $result[$i->channel] = $i->nbuser; return $result; } function printNbUserPerChannelAsTable() { // FIXME catch error ?> $usercount){ ?>

Channel	Connected user