Membergroupids

[Hialls]

Im trying to convert
$sql = "SELECT * FROM user WHERE username = '$PHP_AUTH_USER' AND (usergroupid = '6' or usergroupid = '5')";
to user membergroupids
Normally i would use,

$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:


$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 :)