Secondary Usergroups Query?

[T3MEDIA]

Originally Posted by KirbyDE

[sql]
SELECT * FROM user WHERE FIND_IN_SET('8', membergoupids) OR usergroupid=8;
[/sql]

This will select all members (additional and primary) in group 8.

KirbyDE EVEN MORE offtopic... how do you do a conditional for secondary groups...

I tried <if condition="$bbuserinfo['usergroupid'] == '10' || $bbuserinfo['usergroupid'] == '11' || $bbuserinfo['usergroupid'] == '12' || $bbuserinfo['usergroupid'] == '13' || $bbuserinfo['usergroupid'] == '14' || $bbuserinfo['usergroupid'] == '15'"> stuff </if>

and it didnt work as well as it looks ugly. I tried arrays and got nothing as well. But I think it is becuase my code is looking for primary usergroups...

I want secondary. any help would be great.