Hi, this is something i can't get my head around even though it's not too difficult a concept.
I have a site in php and I'm connecting to a MYSQL database.
I want the user to select conditions from drop down menus and then submit.
For example (a travel agents).
Drop down menu 1: Contains a list of Countries (eg France, Germany.....
Drop down menu 2: Contains a list of prices ($100, $200
If the user selects France and $200 and clicks Submit then the sql query searches the database where rows = France AND $200 and outputs the results.
Connecting to the Database and Drop dwon menu design is no problem for me but I don't know how to put the sql statement together. Any help would be most appreciated.