[toonysnn]

A user on a website I go to has a error just because they have a apostrophy (sp?) in their username.

Originally Posted by Good Ol' Skippy Sniffleflipper

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.

[Neo_obs]

I am getting the same problem is it me or should the \\ be // I am not very good at MySQL but I think thats whats wrong. I guess I will wait for zero to get back from vacation

[toonysnn]

Actually, it's supposed to be like so:

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

Instead of...

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

[MrZeropage]

all problems with those "special characters" are fixed in v2.5.8+ which is about to come in the next days