Show Group Members on Custom Page

[toytaco99]

Ok, I spent about 2 hours last night searching for some help with this and am still stuck.

I'm creating a custom index page on my site to list all of my site donators. This is seperate from the Show Forum Leaders page. It's a PHP page and I've not been using templates because it pulls in items from other parts of the site, too.

So, can someone help me figure out the PHP to create the query of all users in (secondary or primary) group x and display their usernames on a page?

I did this with my old forum (ubb.threads) and it worked fine, but I'm drowning in a sea of PHP code right now.

Thanks in advance for any help.

Ok, I was able to figure it out this morning (7 hours of sleep helps) with the following code:

PHP Code:

$groupid = 19;

        $group = $db->query_read("
            SELECT userid, username
            FROM " . TABLE_PREFIX . "user
            WHERE $groupid IN(membergroupids) OR usergroupid = $groupid
            ORDER BY username ASC
        ");
        
        while ($person = $db->fetch_array($group))
        {
            echo "<option value=\"/forum/member.php?u=$person[userid]\">$person[username]</option>";
        }
        unset($group);
        $db->free_result($group); 


I was actually putting the users into a drop down menu, so that's why there's an "option" tag in there.

Not sure if this snippet of code will help anyone else on here, but if it does, great!