Generating an SQL search query from Drop Down Menu

[cosmic_bird]

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.

[St.]

show sql table structure plz?

and you want exactly $200 or >= $200?

[cosmic_bird]

I want >=200 and <300.

The structure of sql is,

Holiday table with holiday id, Country_name varchar(30), holiday_details varhcar(255), price int (10)

[r937]

select holiday_id
     , country_name 
     , holiday_details
     , price 
  from holiday
 where country_name = 'france'
   and price >= 200
   and price <  300