If possible, a fix to the apostrophe issue would be great. For example I have many users with apostrophes in their user name as seen with
Susan'sMom below. When they complete a game they receive this error:
Quote:
mySQL query error: INSERT INTO games_scores
(mid,gid,name,score,ip,timespent,datescored) VALUES
('22','25','Susan\\'sMom','464','71.100.115.24 7','455','1163219078')
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 'sMom','464','71.100.115.247','455','116321907 8')' at line 3
mySQL error code:
Date: Friday 10th of November 2006 11:24:38 PM
|
The same is occurring within the comments field.
Thanks!