Altering Query

[BamaStangGuy]

Can someone please point me in the right direction on altering this query so that it doesn't pull from my banned usergroup, which is id 16.

PHP Code:

$result = mysql_query("SELECT user.email, user.username FROM user WHERE (options & 16)'"); 


Thanks

[Dismounted]

[sql]SELECT user.email, user.username
FROM user
WHERE (options & 16)
AND usergroupid <> 16
AND FIND_IN_SET(16, membergroupids) = 0[/sql]

[BamaStangGuy]

Thank you