list all users of a usergroup

[Hornstar]

[strike]Yeah that does look like something I would need. However I can't get it to function just yet.
Maybe I am doing something wrong. Any chance you could test it out (also output 2 usergroups).
Thanks again.[/strike]


Edit: Got it to work with 1 usergroup now (So big thanks for that)

PHP Code:

$groupid = 5; // set this to the group id you want
$users = $vbulletin->db->query_read("SELECT username FROM ".TABLE_PREFIX."user
                   WHERE usergroupid = $groupid");
$str = '';
$sep = '';
while ($user = $vbulletin->db->fetch_array($users))
{
    $str .= $sep . $user['username'];
    $sep = ', ';
}
// $str is comma separated list of users in $groupid
$vbulletin->db->free_result($users);  
echo "Super Mods: $str"; 


However not sure which is the best way to get multiple usergroups listed. You mentioned "That does one user group, so you can put that whole thing in a loop, or you could modify the query to get all groups at once and handle the separate lists in the while loop."
Could you give me an example of that.

Also is there a way to get it to list people in both primary and secondary?

Thanks again.