include "config_ioe.php"; $tribalgroup = $_POST['tribalgroup']; $projecttype = $_POST['projecttype']; $town = $_POST['town']; $year = $_POST['year']; $keyword = $_POST['keyword']; $searchitem = ""; if($tribalgroup!=""){ $searchitem = $searchitem." AND (`tribalgroup` like '%$tribalgroup%')"; } if($projecttype!=""){ $searchitem = $searchitem." AND (`projecttype` like '%$projecttype%')"; } if($town!=""){ $searchitem = $searchitem." AND (`town` like '%$town%')"; } if($year!=""){ $searchitem = $searchitem." AND (`year` like '%$year%')"; } if($keyword!=""){ $searchitem = $searchitem." AND ((`name` like '%$keyword%') OR (`projectname` like '%$keyword%') OR (`tribal` like '%$keyword%'))"; } $sql = "SELECT * FROM `lists` where ('1' = '1') $searchitem"; $result = mysqli_query($conn, $sql); ?>