SSI check user is in secondary usergroup

[H]

There are many posts on the forum about checking if the user is logged in or is an admin/moderator.

However is there a way to see if a user is in a secondary usergroup?

[Thantos]

Well it depends on a couple things:
Can that group ever be a primary group?
Do you want to exclude those who have that group as a primary group (if it can be primary)?


If the first is false (ie it can never be a primary group) or the first is true and the second is false then you can just use:
in_array(##, $user_info['groups']);

If the first is true and the second is true then you'll have to do a query

$res = db_query("
 SELECT ID_MEMBER
 FROM {$db_prefix}members
 WHERE ID_GROUP != ##
   AND ## IN (additionalGroups)
   AND ID_MEMBER=$ID_MEMBER
 LIMIT 1", __FILE__, __LINE__);
if ( mysql_num_rows($res) == 0 )
 die("Go away you");
mysql_free_result($res);

[H]

Thanks