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

Code:
$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?