PDA

View Full Version : SQL error - username with special characters


JayT123
07-20-2009, 05:39 PM
Getting this error with users with different characters in their name. Anyway to fix this?

mySQL query error: INSERT INTO vbpmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('6434', '']['he Forgo??en', 'Tournament Information', 'Hello Prophet,

please remember to make your game in the Ninja Turtles 2-Tournament

Click here (\'http://www.legendsforums.com/arcade.php?do=viewtourney&tid=94\') to view this tournament.', 'a:1:{i:0;s:1:\"2\";}', 0, 1248049607, 0, 0)

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 ']['he Forgo??en', 'Tournament Information', 'Hello Prophet,

please remember to ' at line 1
mySQL error code:
Date: Sunday 19th 2009f July 2009 07:26:47 PM