I am building a basic search from to query a rental property database. I have created the following query:

$query="select id,add1,add2,city,rent,bedroom from $tbl_prop where
city='$city' and rent <='$rent' and style='$style' and bedroom >= '$bdrm' order by rent";

The problem is that if the user leaves say the rent dropdown blank then I return 0 results instead of all results regardless of the amount of rent.

Any ideas on how I can make this happen?

Thanks
Lou

use this

$query="select id,add1,add2,city,rent,bedroom from $tbl_prop where
city='$city' ";
if (!empty($rent)){ $query.=" and rent <='$rent' "; }
.....


and so on

BINGO....

Thanks for your help.