Need Some modifications in a php script

IN PROGRESS
Bids
4
Avg Bid (USD)
$47
Project Budget (USD)
$30 - $30

Project Description:
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.

Thank you.

Skills required:
HTML, MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 99
in 999 days
$ 30
in 0 days
$ 30
in 1 days
Hire achillesJK
$ 30
in 0 days