Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Drop down where are you?

Quote Reply
Drop down where are you?
I have 2 drop down menus in my search form. It is for a star rating for hotels. I want the user to select from say Maximum 4 star in one drop down menu and say Minimum 2 star for the second drop down menu.

Now I have created a table called Star where in the add form I will add the actual star rating for the hotel. So what code do I put in the search form? You see if I add 2 drop down menus both calling column Star then it will list all hotels with 4 star and 2 star. What I want is to do that but also all hotels to have 3 star to be listed as well.

Any ideas to do this?