Php, Mysql etc.
Travel Agency search screen.
Search page with dynamic drop downs
1st section at top of search page needs 3 dropdowns
Country pulls from tbl_country
**Fields:** id; fld_country
When country is selected the State/Province Dropdown needs to populate with States/Provinces related to the Country selected
State/Province pulls from tbl_state
**Fields:** id; fld_state; fld_country (Country field here is related to tbl_Country table)
When State is selected the city needs to populate with only cities that fall under the state selected.
City pulls form tbl_city
**Fields:** id; fld_city; fld_state (state is related to state table)
The next will be two drop down boxes and search button.
The two drop down boxes will have price in them. From and To
The user specifies what price range they want to go on holiday for. example $0 - $500
The main table that needs to be searched is the tbl_destinations
Fields: id; fld_destname; fld_country; fld_state; fld_city; fld_contactemail; fld_price
more development will be given to the person who can deliver this without using complicated code and very little extra requirements like installing other requirements etc.
you are allowed to use java php ajax jquery to acheive the result.