toonysnn
11-27-2006, 01:34 AM
A user on a website I go to has a error just because they have a apostrophy (sp?) in their username.
mySQL query error: UPDATE games_champs SET champ_gid='123',champ_gtitle='Togy Ball',champ_mid='28949',champ_name='Good Ol\\' Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_gid=123
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 'Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_g' at line 1
mySQL error code:
Date: Sunday 26th 2006f November 2006 06: 30 :39 PM
I can't really explain what it is and why I keep getting this messege when I try to submit a score.
mySQL query error: UPDATE games_champs SET champ_gid='123',champ_gtitle='Togy Ball',champ_mid='28949',champ_name='Good Ol\\' Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_gid=123
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 'Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_g' at line 1
mySQL error code:
Date: Sunday 26th 2006f November 2006 06: 30 :39 PM
I can't really explain what it is and why I keep getting this messege when I try to submit a score.