[Hialls]

Im trying to convert

PHP Code:

$sql = "SELECT * FROM user WHERE username = '$PHP_AUTH_USER' AND (usergroupid = '6' or usergroupid = '5')"; 


to user membergroupids
Normally i would use,

PHP Code:

$sql = "SELECT * FROM user WHERE username = '$PHP_AUTH_USER' AND (usergroupid = '6' or usergroupid = '5' or membergroupids like '%7%')"; 


However this would mean a user could be member of group 7, or group 27 and still get in. Im wondering how else i could code this?