Hello! First of all you should know that I'm beginner with php, so perhaps this is fairly easy to accomplish but it's nightmare for me now I have this situation with my website: - Search form which search through several fields of the products table (like title, color, condition, delivery). I also have the field for the price which at this moment is simple text field in the form, and visitor should enter the price here to search for. What I want to to now is instead this price field in my form to place a list/menu with select fields with values like: <$50 $50 - $100 $100 -$150 $150 - 200 etc. You get the idea anyway. How can I accomplish that a form searches through all the values in a price group ie $50, $51, %52, ..... , $100 and return the right results ? I fope I was clear enough and I hope there's someone out there who can point me to the right direction. Thank you
ok. this will deal more on your query.. do these <$50 $50 - $100 $100 -$150 $150 - 200 etc. in your database?