<?php 
// Include the database config file 
include_once 'config.php'; 
 
if(!empty($_REQUEST["area"]) OR !empty($_REQUEST["brand"]) OR !empty($_REQUEST["category"])){ 
    // Fetch state data based on the specific country 
	if($_REQUEST["category"] == "Appliance"){
	 $query = "SELECT * FROM tb_branch WHERE area like '%".$_REQUEST['area']."%' AND category like '%".$_REQUEST['category']."%' ORDER BY branch ASC"; 
    $result = $con->query($query); 
     
    // Generate HTML of state options list 
    if($result->num_rows > 0){ 
        echo '<option value="">Select branch</option>'; 
        while($row = $result->fetch_assoc()){  
            echo '<option value="'.$row['root_name'].'">'.$row['root_name'].'</option>'; 
        } 
    }else{ 
        echo '<option value="">Branch not available</option>'; 
    } 
	}ELSE{
		
	$query = "SELECT * FROM tb_branch WHERE area like '%".$_REQUEST['area']."%' AND category LIKE '%".$_REQUEST['category']."%' AND brand LIKE '%".$_REQUEST['brand']."%' ORDER BY branch ASC"; 
    $result = $con->query($query); 
     
    // Generate HTML of state options list 
    if($result->num_rows > 0){ 
        echo '<option value="">Select branch</option>'; 
        while($row = $result->fetch_assoc()){  
            echo '<option value="'.$row['root_name'].'">'.$row['root_name'].'</option>'; 
        } 
    }else{ 
        echo '<option value="">Branch not available</option>'; 
    } 
		
	}
   
}
?>