Good day! I do a sample:

$result = mysql_query("SELECT `id` FROM `alerts` WHERE `whom`='$user' AND `type`='3' OR `type`='4' OR `type`='5' OR `type`='6'") or die(mysql_error());

I expect to get everything from the database, where the user = $ user and types 3, 4, 5, 6, BUT displays not about one user, but about all, what is the error?

    1 answer 1

     $result = mysql_query("SELECT `id` FROM `alerts` WHERE `whom`='$user' AND (`type`='3' OR `type`='4' OR `type`='5' OR `type`='6')") or die(mysql_error());

    Condition grouping must be used