[NickPR]

thx KirbyDE. I think this will work if i could only use it properly :P

I first assigned it to a var: $result = $DB_site->query_first("select userclassid, count(userclassid) as total from user group by userclassid");

and then it just showed as 'Array' in each case of $result in the output. So i modified the string in the html template to call $result[total] but now it outputs what appears to be the total of all users (506).

Where am i going wrong ?

heres the modified code:

PHP Code:

process_userinfo();
    
    $userclassid = $user['userclassid'];
    $getuserstatus=$DB_site->query_first("SELECT title FROM useractive WHERE useractiveid=$user[activestatus]");
    $getuserrace=$DB_site->query_first("SELECT title FROM userrace WHERE userraceid=$user[userraceid]");
    $getusergroup=$DB_site->query_first("SELECT title FROM usergroup WHERE usergroupid=$user[usergroupid]");
    $getuserrank=$DB_site->query_first("SELECT title FROM userrank WHERE userrankid=$user[userrankid]");
    $getusergender=$DB_site->query_first("SELECT title FROM usergender WHERE usergenderid=$user[usergenderid]");
                    
    if (!$grouptitle[$usergroupid]) {
            $grouptitle[$userclassid] = $user['title'];
    }
    eval("\$groupinfo[$userclassid] .= \"".fetch_template("rollcall_bit2")."\";");

}

if (is_array($groupinfo)) {
    while(list($key, $val) = each($groupinfo)) {
        $result = $DB_site->query_first("select userclassid, count(userclassid) as total from user group by userclassid");
        $classname = $grouptitle["$key"];
        if (substr($classname,-1)!="s") {
            $classname.="s";
        }
        
        
        $adminbits = $val;
        eval("\$groupbits .= \"".fetch_template("rollcall_group2")."\";");
        
    }

}