Here is the deal. I have a php script that among other things recovers variables of LATITUDE and LONGITUDE from a mysql DB and shows icons in google maps api.
The script already has a form to add new stuff to the map, when I click anywhere in the map, it fills-up the form lat and long fields, so I just need to type a name and a few more information and it creates the table entry, after refreshing the page, it shows in the map.
I also have a "relations" table which basically has 3 fields, ID, ID_from, ID_to, where I store the information of which item is connected to which item, for example: ID=1, ID_from=200, ID_to=233, makes the google maps api create a linking red line between items 200 and 233.
My problem is to remove items from the map, I currently have to do it manually through PhpMyadmin, and I have to manually check the "relations table" if no other item is connected to the item I want to delete, which could be done a whole lot faster using Mysql querys.
So the job is:
- Add a form to delete items from the DB
- Check if the item ID is not connected to any other Item, and if it is make the necessary modifications
- Find out why the form that creates Items "relations" sometimes doesn't work.