i found a bug in this today, though i'm not sure it's something that is fixable..
a user with an apostrophe in his username tried adding himself to the map, and it caused a db error. obviously the sql is reading it as an extra beginning quote, without an end..
can this be fixed?
Code:
Invalid SQL:
INSERT INTO googlemap (userid,username,usergroupid,text_map,lat_map,lng_map) VALUES ('430','test'user','11','testing','-18.646245142670608','-55.37109375');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user','11','testing','-18.646245142670608','-55.37109375')' at l Error Number : 1064