I have implemented the PHP/MySQL example from here: http://code.google.com/support/bin/answer.py?answer=65622 but I would like to take it further and create an editing page where I can edit the attributes of the markers. I suspect it's either in my edit page or in the UPDATE code itself.
Here is the page: http://swcagis.com/offices/edit_locations.html Here is the code for the UPDATE command: // Insert new row with user data //=============================================================== $query = sprintf("UPDATE offices " . " SET name = '%s', address = '%s', phone1 = '%s', phone2 = '%s', fax1 = '%s', mp = '%s' ,admin = '%s' " . " WHERE id = '%s' LIMIT 1;", // escape strings mysql_real_escape_string($id), mysql_real_escape_string($name), mysql_real_escape_string($address), mysql_real_escape_string($phone1), mysql_real_escape_string($phone2), mysql_real_escape_string($fax1), mysql_real_escape_string($mp), mysql_real_escape_string($admin)); $update_result = mysql_query($query); if (!$update_result) { die("Invalid query: " . mysql_error()); } Tables have full permissions for user. Could there be a conflict from the original call to the database where the data are supplied for populating the form? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
