Search php function from multiple combobox

I have 3 combobox, i want search function who really user friendly like if I choose "Hot deals" on 1st combobox then leave "ALL" for 2nd combobox and 3rd combobox, it's mean the result after press button submit will be "SELECT * from property where id_status='2'" ----or---- if I leave 1st combobox to be "All" and I choose "Seminyak" for 2nd combobox and choose "Land for sale" for 3rd combobox, it's mean the result will be "SELECT * from property where id_area='seminyak' and id_type='land for sale'" ---and etc.. whatever the user choose from 3 combobox"

here my code html

<form method="post" action="property-sortir.php"> <p> <input type="hidden" name="id" value="<?php echo "$_GET[id]";?>"> Location : <b><?php echo "$location"; ?></b><br> Category : <select name="status"> <option value="0" selected >All</option> <option value="1" style="color: blue;">New</option> <option value="2" style="color: red;">Hot Deals</option> <option value="3">Normal</option> </select> Area : <select name="area"> <option value="0" selected >All</option> <?php $sql=mysql_query("select * from area where id_location=$_GET[id]"); while($r=mysql_fetch_array($sql)){ echo"<option value='$r[id_area]'>$r[nama_area]</option>"; } ?> </select> Types : <select name="type"> <option value="0" selected>All</option> <?php $sql=mysql_query("select * from type where id_location=$_GET[id]"); while($r=mysql_fetch_array($sql)){ echo"<option value='$r[id_type]'>$r[nama_type]</option>"; } ?> </select> <button type="submit">Search</button> </form>

and here the code of property-sortir.php

<?php
if ($_POST['id']==1){
$location="Bali";
}
else{
$location="NTT";
}
$status=$_POST['status'];
$area=$_POST['area'];
$type=$_POST['type'];
$property2 = mysql_query("select * from property where id_location='$_POST[id]' AND id_status='$_POST[status]' AND id_area='$_POST[area]' AND id_type='$_POST[type]' order by id_property DESC");
while($s=mysql_fetch_array($property2)){
<!--blablabla-->
}
?>

but the problem is, I can't display result flexible or just limited. help me please