On Wed, 15 Sep 2004 23:30, Peppe wrote: > 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 need help when the user chose option value 3 till 200.000 than the query > should search between 175.000 and 200.000 how to achive this > Regards SELECT fields FROM table WHERE something BETWEEN 175.000 AND 200.000 More information at http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html or see the docs for whatever other database you use. -- David Robley "What's the value of a dollar bill?" asked Tom noteworthily. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
