I need someone to look at some code I have already written and help me to create the correct AJAX code to allow for the database to create the correct drop down fields and populate them with the info from the mySQL db. I also need to be able to add new items to the existing options list and update all of this information for a particular property. To clarify, I am able to update the property data no problem (ref table: auth_properties) however I am dynamically building the options for the property from referencing other tables and then want to write that updated data back to the (ref table: auth_options).
Please look at the following web page using the login information provided before bidding as most of this code is written I am just at a snag in the updating process. I know this is a $.each / for each type of solution and shouldn't take but maybe 30mins to an hour fix.
Login URL: [url removed, login to view]
--> Click on Administrative functions, then click on Modify Properties. Adding a property and the options for a property works just fine. Its when I go to edit the property added, it is not pulling up the options that were previously added to the property therefore not allowing me to update them or add new options.
I have included all files relevant to the code for review.
Lines: 945 to 1389 contain the tab html and jquery/ajax for properties in [url removed, login to view]
[url removed, login to view] and [url removed, login to view] are the two files used for the AJAX calls.
MySQL Tables included in files