Query Help Please

[BamaStangGuy]

I need to alter this query so that it only pulls the fields that have "Receive Email From Admins" checked

$result = mysql_query("SELECT user.email, user.username
FROM user ");

[Opserty]

Try:

$result = mysql_query("SELECT user.email, user.username FROM user WHERE (options & 16)");
That should be right.

[BamaStangGuy]

Thanks a bunch. This worked

--------------- Added 1216916888 at 1216916888 ---------------

Would it be possible to add on to that so that it doesn't pull the information from usergroupid 16?