I make this sample from the base

$result_likes = mysql_query("SELECT * FROM likes_order WHERE user_sex='$user_sex' or user_sex='$user_sex_nan' AND user_country='$user_country' or user_country='$user_country_nan' AND order_user_uid!='$user_uid' ");

But does not work! What could be the reason?

  • Sampling takes place only in one parameter - Anatoly

1 answer 1

Brackets Your problem:

 SELECT * FROM likes_order WHERE (user_sex='$user_sex' or user_sex='$user_sex_nan') AND (user_country='$user_country' or user_country='$user_country_nan') AND order_user_uid!='$user_uid

And, probably, it is more understandable like this:

 SELECT * FROM likes_order WHERE user_sex IN ('$user_sex', '$user_sex_nan') AND user_country IN ('$user_country', '$user_country_nan') AND order_user_uid!='$user_uid
  • Here I have braked, thanks a lot for the help - Anatoly