Option box and Database

[Eal]

On my project I am needing some help about implementing an option box and using mysql database. What I am planning to do is to have an option box with price, for example,

100 - 500
501 - 1000
1000 - 1500

And I have price of each item saved in my database, like 50, 100, 150, 200, 250, 300

Then I want that once the option is selected in the option box, then my query go through the database and looks any item of that range and show that.

I am bit uncomfortable working with option box and having query on them. How can you get value of option selected in a variable? How can you query them?

I will have about 4 different options boxes and the query will be performed on basis of options selected in four options boxes

Any help would be appreciated!

[barand]

switch ($_POST['priceOption']) {
case 1:
$lo = 100;
$hi = 500;
break;
case 2:
$lo = 501;
$hi = 1000;
break;

//etc

}
$sql = "select * from table where price between $lo and $hi "

hth