I need a form/database setup for a Tourist Guides section of a website
I need tables setup to handle 6 variables
Country, Area, Region, County/State, Town, Postcode/zip
Phase one is to be used in the UK.
I need Country, County, Town, Postcode populating into the database. I have the details for postcode/town and town/County as separate lists. they need collating and importing into the tables. The Area and Region will have to be added manually.
The forms will need Php/mysql code for 2, 3, 4 and 5 section relational drop menu ( each field to submit in a form)
I need a number of variations of form and for it to work in both directions
1 - select country and input postcode - this to then use postcode to lookup and define town, and county as either hidden fields, display fields or submit to DB in a form.
2 - select country, which populates Counties dropdown, select county which populates towns menu, and option for another drop to select postcode.
3 - simple version in search form: Select country - populate region
4 - simple version in search form: Select country - populate area
All forms and code to be properly commented to allow editing a future date
Please quote for Phase one
Phase 2 would be the US and France Spain, italy and other european countries. please message me with a cost per country for this phase 2 work