MySQLi Search Filters
I have a search form with 3 fields:
<form id="searchForm" action="search_results.php" method="GET" name="searchForm">
<div class="row">
<div class="form-group">
<div class="col-md-12">
<label><em>Search by Business Type</em></label>
<input type="text" value="" class="form-control" name="Category" id="Category" >
</div>
<div class="col-md-12">
<label><em>Search by Business Name</em></label>
<input type="text" value="" class="form-control" name="Business" id="Business" >
</div>
<div class="col-md-12">
<label><em>Search by Suburb</em></label>
<input type="text" value="" class="form-control" name="Suburb" id="Suburb" >
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<input type="submit" value="Search" class="btn btn-primary btn-lg" data-loading-text="Loading...">
</div>
</div>
</form>
And a results page with filters:
<?php
$rsResults = new WA_MySQLi_RS("rsResults",$MyConnect,0);
$rsResults->setQuery("SELECT * FROM directory WHERE Category LIKE ? OR Business LIKE ? AND Suburb = ? ORDER BY Business ASC");
$rsResults->bindParam("c", "".(isset($_GET['Category'])?$_GET['Category']:"") ."", "-1"); //paramCat
$rsResults->bindParam("c", "".(isset($_GET['Business'])?$_GET['Business']:"") ."", "-1"); //paramNam
$rsResults->bindParam("s", "".(isset($_GET['Suburb'])?$_GET['Suburb']:"") ."", "-1"); //paramSub
$rsResults->execute();
?>
However, the filters are not narrowing the results to suburb, just displaying ALL the results for the Category searched.