PHP SQL Question

[ryanfilard]

I am trying to make my database search only search where private = '$priiv'(Usually 0,1, or 2) but it does not work

 
$query_search = "SELECT * FROM users WHERE username LIKE '%$idea%' OR fname LIKE '%$idea%' OR lname LIKE '%$idea%' OR tags LIKE '%$idea%' AND private = '$priiv'";

 

What am i doing wrong?

[Pikachu2000]

What about it "does not work"?

[ryanfilard]

AND private = '$priiv'

[DavidAM]

AND takes precedence over OR so basically, that statement says:

 

SELECT * FROM users 
WHERE username LIKE '%$idea%' 
OR fname LIKE '%$idea%' 
OR lname LIKE '%$idea%' 
(OR tags LIKE '%$idea%' AND private = '$priiv')

So it only checks the private column when checking the tags column.

 

You need to use parenthesis to group the OR's all together:

SELECT * FROM users 
WHERE (username LIKE '%$idea%' 
    OR fname LIKE '%$idea%' 
    OR lname LIKE '%$idea%' 
    OR tags LIKE '%$idea%') 
AND private = '$priiv'

 

or, rearrange it to something easier to read (IMO)

SELECT * FROM users 
WHERE private = '$priiv'
AND (username LIKE '%$idea%' 
    OR fname LIKE '%$idea%' 
    OR lname LIKE '%$idea%' 
    OR tags LIKE '%$idea%')