Hi, i am setting up a real estate database and i am wondering how to do 2 things...
In my index page I have a quick search form. I have the choises of
Listing Type (Any, Rent, Sale)
Region (Any, Region1, Region2, etc)
Property Type (Any,House, Flat, etc)
Minimum Price (Any, Price1, Price2, etc)
Maximum Price (Any, Price1, Price2, etc)
a. How do i use the price field to check between the min and max ? To be more clear, i have a field in my table called price and lets say the user wants to check properties between 100,000 and 200,000 so i guess the minimum and the maximum have to be checked against the price field in the database. How do I do that?
b. How the Any choice in the dropdown works? What do i need to have extra in order when the user chooses any to give them all the results for the specific choice