using the AND & OR statments

[adrianuk29]

Ok i have two drop down menus that I use to search my database, I can do this fine, however how do I go about searching my database when only one drop down menu has been selected. I have tried using the OR statment in my code and then AND statment but cannot figure out how to search becayse AND would require two drop down menus being selected and OR would require only one drop down menu to be selected, how do I combine the two?
Your help would be greatly appreciated.

[mourisj]

2 possible solutions:

1. Add an item in your drop-down which is selected by default; you just have to give it an adequate value to insure your query can always work with that value.

2. Check if the values are set and dependiing on the result build your query differently and submit it to the DB

Have a nice day,

JJ Mouris

[adrianuk29]

Thank you very much for your reply I managed to do it another way using AND like '%keyword%' in the select statment. It seems to do the trick for some reason so now even if one drop down is not filled in then it will start search on one and vice versa plus it will search together.