Search query

[rakuci]

Hi
I have a option box with values
<select name="prijsklasse" class="bodyzwart" id="prijsklasse">
<option value="1" selected>Less than 150.000
<option value="2">tot 175.000
<option value="3">tot 200.000
<option value="4">tot 250.000
<option value="5">tot 300.000
<option value="6">tot 350.000
<option value="7">tot 400.000
<option value="8">More than 400.000
</select>
i have table kavels with column prijs

I need help when the user choose option value 3 tot 200.000 then the query
should search between 175.000 and 200.000 if user choose 400.000 then it should search between 350.000 and 400.000

Thanx in advance

[olaf]

Maybe: "select from kavels where prijs < $prijsklasse"

This for the query, you have to know in your application that 3 == 200.000 or you have to handle the value in place of the index.