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!

[---MAD---]

Originally Posted by 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!

hmm no one has replied.
I tried your code, it doesnt use the templates or styles and doesnt look good. It just shows all my users on next to each other. Not spaced out.
Maybe someone can add to it :s?

[djjeffa]

bump I would like to see a good code to create this kind of page.

[top end ms]

How can I get the list to print out in the middle of my template? Right now it always prints at the top above the header. ..

[Protonus]

Bump again. I'm looking for this as well.