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.;)

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 ;) )

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???:confused:

try the sql query if you have this.

I didnt get ur meaning, sorry

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.

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.

can u do it with new select statment?

I think this might work

not 100% sure.