Hola tengo una pagina de bienes raices que tiene un buscador es asi su codigo
<form id="form1" name="form1" method="post" action="buscar.php">
<div id="spryradio1">
<label>
<input name="tipo" type="radio" id="tipo" value="venta" checked="checked" />
Compra</label>
<label>
<input type="radio" name="tipo" value="renta" id="tipo" />
Renta</label>
</div>
<span id="spryselect1">
<br></br><label for="zona"></label>
<select name="zona" id="zona">
<option value="jurica">Jurica</option>
<option value="juriquilla" selected="selected">Juriquilla</option>
<option value="el refugio">El refugio</option>
<option value="otras">Otras</option>
<option value="Cumbres del Lago">Cumbres del Lago</option>
<option value="Juriquilla Santa Fe">Juriquilla Santa Fe</option>
<option value="Juriquilla Punta ">Juriquilla Punta </option>
<option value="Juriquilla San Francisco">Juriquilla San Francisco</option>
<option value="Juriquilla Misiones">Juriquilla Misiones</option>
<option value="Juriquilla Toliman">Juriquilla Toliman</option>
<option value="Juriquilla Villas del Meson">Juriquilla Villas del Meson</option>
<option value="Juriquilla Real de ">Juriquilla Real de </option>
</select>
Elige Zona</span>
<p><span id="spryselect2">
<label for="propiedad"><br />
Elige tipo propiedad</label>
<select name="propiedad" id="propiedad">
<option value="todos" selected="selected">Todos</option>
<option value="casa">Casa</option>
<option value="Terreno">Terreno</option>
<option value="local">Local</option>
<option value="otros">Otros</option>
</select>
</span></p>
<p>Precio Min<span id="spryselect3">
<label for="precio"></label>
<select name="precios" id="precios">
<option value="250,000" selected="selected">250,000</option>
<option value="500,000">500,000</option>
<option value="750,000">750,000</option>
<option value="1,000,000">1,000,000</option>
<option value="1,250,000">1,250,000</option>
<option value="1,500,000">1,500,000</option>
<option value="1,750,000">1,750,000</option>
<option value="2,000,000">2,000,000</option>
<option value="2,250,000">2,250,000</option>
<option value="2,500,000">2,500,000</option>
<option value="2,750,000">2,750,000</option>
<option value="3,000,000">3,000,000</option>
<option value="3,250,000">3,250,000</option>
<option value="3,500,000">3,500,000</option>
<option value="3,750,000">3,750,000</option>
<option value="4,000,000">4,000,000</option>
<option value="4,250,000">4,250,000</option>
<option value="4,500,000">4,500,000</option>
<option value="4,750,000">4,750,000</option>
<option value="5,000,000">5,000,000</option>
<option value="5,250,000">5,250,000</option>
<option value="5,500,000">5,500,000</option>
<option value="5,750,000">5,750,000</option>
<option value="6,000,000">6,000,000</option>
<option value="6,250,000">6,250,000</option>
<option value="6,500,000">6,500,000</option>
<option value="6,750,000">6,750,000</option>
<option value="7,000,000">7,000,000</option>
<option value="7,250,000">7,250,000</option>
<option value="7,500,000">7,500,000</option>
<option value="7,750,000">7,750,000</option>
<option value="8,000,000">8,000,000</option>
<option value="8,250,000">8,250,000</option>
<option value="8,500,000">8,500,000</option>
<option value="8,750,000">8,750,000</option>
<option value="9,000,000">9,000,000</option>
<option value="9,250,000">9,250,000</option>
<option value="9,500,000">9,500,000</option>
<option value="9,750,000">9,750,000</option>
<option value="10,000,000">10,000,000</option>
<option value="10,250,000">10,250,000</option>
<option value="10,500,000">10,500,000</option>
<option value="10,750,000">10,750,000</option>
<option value="11,000,000">11,000,000</option>
<option value="11,250,000">11,250,000</option>
<option value="11,500,000">11,500,000</option>
<option value="11,750,000">11,750,000</option>
<option value="12,000,000">12,000,000</option>
<option value="13,000,000">13,000,000</option>
<option value="14,000,000">14,000,000</option>
<option value="15,000,000">15,000,000</option>
<option value="16,000,000">16,000,000</option>
<option value="17,000,000">17,000,000</option>
<option value="18,000,000">18,000,000</option>
<option value="19,000,000">19,000,000</option>
<option value="20,000,000">20,000,000</option>
<option value="21,000,000">21,000,000</option>
<option value="22,000,000">22,000,000</option>
<option value="23,000,000">23,000,000</option>
<option value="24,000,000">24,000,000</option>
<option value="25,000,000">25,000,000</option>
<option value="26,000,000 Mas ">26,000,000 Mas </option>
</select>
</span></p>
<p>Precio Máx<span id="spryselect4">
<label for="precio_"></label>
<select name="precioss" id="precioss">
<option value="250,000">250,000</option>
<option value="500,000" selected="selected">500,000</option>
<option value="750,000">750,000</option>
<option value="1,000,000">1,000,000</option>
<option value="1,250,000">1,250,000</option>
<option value="1,500,000">1,500,000</option>
<option value="1,750,000">1,750,000</option>
<option value="2,000,000">2,000,000</option>
<option value="2,250,000">2,250,000</option>
<option value="2,500,000">2,500,000</option>
<option value="2,750,000">2,750,000</option>
<option value="3,000,000">3,000,000</option>
<option value="3,250,000">3,250,000</option>
<option value="3,500,000">3,500,000</option>
<option value="3,750,000">3,750,000</option>
<option value="4,000,000">4,000,000</option>
<option value="4,250,000">4,250,000</option>
<option value="4,500,000">4,500,000</option>
<option value="4,750,000">4,750,000</option>
<option value="5,000,000">5,000,000</option>
<option value="5,250,000">5,250,000</option>
<option value="5,500,000">5,500,000</option>
<option value="5,750,000">5,750,000</option>
<option value="6,000,000">6,000,000</option>
<option value="6,250,000">6,250,000</option>
<option value="6,500,000">6,500,000</option>
<option value="6,750,000">6,750,000</option>
<option value="7,000,000">7,000,000</option>
<option value="7,250,000">7,250,000</option>
<option value="7,500,000">7,500,000</option>
<option value="7,750,000">7,750,000</option>
<option value="8,000,000">8,000,000</option>
<option value="8,250,000">8,250,000</option>
<option value="8,500,000">8,500,000</option>
<option value="8,750,000">8,750,000</option>
<option value="9,000,000">9,000,000</option>
<option value="9,250,000">9,250,000</option>
<option value="9,500,000">9,500,000</option>
<option value="9,750,000">9,750,000</option>
<option value="10,000,000">10,000,000</option>
<option value="10,250,000">10,250,000</option>
<option value="10,500,000">10,500,000</option>
<option value="10,750,000">10,750,000</option>
<option value="11,000,000">11,000,000</option>
<option value="11,250,000">11,250,000</option>
<option value="11,500,000">11,500,000</option>
<option value="11,750,000">11,750,000</option>
<option value="12,000,000">12,000,000</option>
<option value="13,000,000">13,000,000</option>
<option value="14,000,000">14,000,000</option>
<option value="15,000,000">15,000,000</option>
<option value="16,000,000">16,000,000</option>
<option value="17,000,000">17,000,000</option>
<option value="18,000,000">18,000,000</option>
<option value="19,000,000">19,000,000</option>
<option value="20,000,000">20,000,000</option>
<option value="21,000,000">21,000,000</option>
<option value="22,000,000">22,000,000</option>
<option value="23,000,000">23,000,000</option>
<option value="24,000,000">24,000,000</option>
<option value="25,000,000">25,000,000</option>
<option value="26,000,000 Mas ">26,000,000 Mas </option>
</select>
</span></p>
<p>
<input type="submit" name="enviar" id="enviar" value="Enviar" />
<input type="reset" name="restablecer" id="restablecer" value="Restablecer" />
</p>
</form>
se envia tal informacion a buscar.php
y en buscar.php
tengo una busqueda en la base datos
SELECT *
FROM propiedades
WHERE propiedades.tipo LIKE %coltipo% AND propiedades.zona LIKE %colzona% AND propiedades.propiedad LIKE %colpropiedad% AND
propiedades.precio BETWEEN %colmin% AND %colmax%
ORDER BY propiedades.zona ASC
propiedades.precio es un campo que almacena el precio de la propiedad
colmin y colmax son unas variables que recuperan el texto seleccionado del primer formulario precio minimo y maximo
como hago para que busquen propiedades con el precio soy nuevo aqui gracias