I need two php pages done.
See attached file for database.
Possible to select one of the areas (table lan) from dropdown.
When selected all the citys from table ort belonging to that area (lanID)is displayed in list.
It should be possible to change area (lanID) on the city, renname it and delete it.
It should be possible to add new city.
In the list of cities it should be possible to click on a link that will display page 2
The city name is displayed (table ort, column ort)
A list of all cities being inside 50km area to this city are displayed (table 50km). It should be possible to
add and remove cities from this list.
When a city is added or removed it should also be added or removed from the opposite direction
I click on city with ortID 5.
I add city with ortID 8 to the list of cities inside 50 km area.
insert into table 50km should then be ortID 5, inside_50km_ortid 8 and also
ortID 8, inside_50km_ortid 5.
The same goes when deleting a entry.
delete ortid 8, inside_50km_ortid 5 should also delete ortid 5, inside_50km_ortid 8
The list of cities to add should be displayed in dropdowns. one dropdown to select area, when this is selected the other dropdown is filled with the cities belonging to that area.
no design is needed for the pages.