PHP web pages

PHP web pages is project number 136676 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider phpfarmer
Budget:	$30-100
Created:	04/05/2007 at 6:47 EDT
Bidding Ends:	04/07/2007 at 6:47 EDT
Project Creator:	Ruilong   Buyer Rating: (17 reviews)
Description:	I need two php pages done. See attached file for database. Page 1 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 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 example 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. Additional files submitted: lan_ort_50km.sql
Job Type:	PHP
Database:	MySQL
Operating system:	(None)
Bid count:	13
Average bid:	$ 61