Query Help Please

[BamaStangGuy]

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

PHP Code:

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

[Opserty]

Try:

PHP Code:

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

That should be right.

[BamaStangGuy]

Thanks a bunch. This worked

--------------- Added [DATE]1216916888[/DATE] at [TIME]1216916888[/TIME] ---------------

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