Membergroupids

[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?

[Xenon]

that way:

PHP Code:

$sql = "
SELECT *
FROM user
WHERE username = '$PHP_AUTH_USER' AND (usergroupid IN (5 , 6) OR CONCAT(',', membergroupids, ',') LIKE '%,7,%')
"; 


[Hialls]

Ah sweet thankyou, that will allow for the possible "," i assume?

[Xenon]

oops, i put ' ' where ',' was needed.

i edited it again

[Hialls]

Thankyou once again, much appreciated

[Xenon]

you're welcome