MySQL query WHERE AND OR

[noahssite]

Hello, here is a query that is executed when the search button is clicked.

$query = "SELECT * FROM sites WHERE region LIKE '%$searchContent%' OR banner LIKE '%$searchContent%' OR site LIKE '%$searchContent%' OR comment LIKE '%$searchContent%' OR lastupdated LIKE '%$searchContent%' AND company='$company'";

As you see it searches for $searchContent using WHERE...LIKE...OR in all the columns listed. The last part of the query is the final condition, AND company='$company'.

Basicly the user can search all the columns as long as the column company is eqaul to a variable called $company. This is not working, instead AND company='$company' is being ignored. The user has access to all the columns.

Is it that fact that AND company='$company' is at the end of the query after all the OR's? How would I fix this up?

[techgnome]

by using parenthesis to force the order of operations to your will....

$query = "SELECT * FROM sites WHERE ((region LIKE '%$searchContent%') OR (banner LIKE '%$searchContent%') OR (site LIKE '%$searchContent%') OR (comment LIKE '%$searchContent%') OR (lastupdated LIKE '%$searchContent%')) AND (company='$company')";

With the parenthesis I added, it will return where any ONE of the or clauses is true, AND the company matches.

-tg