[sgeiger]

Chen,

How could I change this query to only show members of a usergroup when one clicks on memberlist.

I want no outside groups to see the members of other user groups.

Group A to see only group A members in memberlist....
and
Group B to only see group B members in member list....

Originally Posted by Chen

Err I'm in a bit of a hurry, but try replacing this in memberlist.php:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE $condition AND

with this:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
                          WHERE $condition AND

then try using $user[title] in the memberlistbit template.

Hope this works.