Secondary permissions usergroupid

[Daniel]

Greettttings! I'm trying to get this working... it should pull up and display users from a secondary user group ("9") on a vB page.

$veteran_members = $db->query("
SELECT userid, usergroupid,
IF(usergroupid==9, usergroupid, usergroupid) AS usergroupid,
username, lastpostid, posts, joindate
FROM " . TABLE_PREFIX . "user AS user
ORDER BY joindate ASC
LIMIT $count
");

(This is the only part of the code which I need help with. It is modified from the original code which showed new members, seen below)

[kh99]

I think you want something like this:

$groupid = 9;
$veteran_members = $db->query("
SELECT userid, usergroupid,
IF (displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,
username, lastpostid, posts, joindate
FROM " . TABLE_PREFIX . "user AS user
WHERE (FIND_IN_SET($groupid, membergroupids) OR user.usergroupid = $groupid)
ORDER BY joindate ASC
LIMIT $count
");

[Daniel]

Ladies and gentlemen...... my hero!!!!!

To anyone else who stumbles upon this, just replace the code kh99 mentioned with the code I mentioned above. Simple as that!