Listing a usergroup on non vb php page...

[por4x4]

Ok, I have a usergroup composed of paying advertisers. I want to create an ad index that lists their username, location, and web address (just like the 'show forum leaders' does). Is this possible to do on a non vb .php page?

TIA...

[Andreas]

Basically it's

SELECT userid, username, field2 FROM user LEFT JOIN userfield ON (userfield.userid=user.userid) WHERE usergroupid=X OR FIND_IN_SET('X', membergroupids)

Where X is the ID of this usergroup.