small request plz

[SilverBoy]

thx Kier but I tried it on vb115 and work fine, but it is not what i want, I wanna to display usertitles not usergroups, sorry for bothering u but can u to modify it.

[polgas]

Replace Kier's SQL query with this:

SELECT user.usertitle, COUNT(userid) AS users
FROM user
GROUP BY user.usertitle

Hope this helps.

Lol Pef,don't forget that Kier is the better php coder's of the World (for vbulletin )

[SilverBoy]

I have 4 users in my test board, and when I test it, it gived me a list without titles only numbers, and they was 3 numbers only, but I have 4 titles to those users, any help???

[polgas]

try the sql query if you have this.

[SilverBoy]

I didnt get ur meaning, sorry

[polgas]

Do you know if you have phpmyAdmin access to your site? If you have, run the SELECT statement I posted and see if you get the result you wanted.

[SilverBoy]

I checked in phpmyadmin and it was very nie, I think there are some modification in the rest of kier code to display every thing correctly in the index page, any help.

[SilverBoy]

can u do it with new select statment?

PHP Code:

$users = $DB_site->query("SELECT user.usertitle, COUNT(userid) AS users
    FROM user
    GROUP BY user.usertitle");
    while ($user = $DB_site->fetch_array($users)) {
        $usertotals .= "$user[usertitle] ($user[users])<br>";
    } 


I think this might work

not 100% sure.