|
I'm having some troubles. I have an install script which runs
a lot of SQL statements to create tables then insert info into them. One of them
is an emoticons table. Here's the error I'm getting:
You have an error in your SQL syntax near '; INSERT INTO c_emotes VALUES
\(':\)', 'emotes/smile.gif'\); INSERT INTO c_emo' at line 4
or, if I change my code a little, it's this:
You have an error in your SQL syntax near '; INSERT INTO c_emotes VALUES
\(':)', 'emotes/smile.gif'\); INSERT INTO c_emo' at line 4
Here's my code which inserts the information:
INSERT INTO c_emotes VALUES (':)', 'emotes/smile.gif'); // I
also have tried placing a \ infront of the )...no luck
INSERT INTO c_emotes VALUES (';)', 'emotes/wink.gif'); INSERT INTO c_emotes VALUES (':(', 'emotes/sad.gif'); INSERT INTO c_emotes VALUES (':P', 'emotes/tounge.gif'); INSERT INTO c_emotes VALUES (':|', 'emotes/blank.gif'); INSERT INTO c_emotes VALUES (':-|', 'emotes/blank.gif'); INSERT INTO c_emotes VALUES (':-)', 'emotes/smile.gif'); INSERT INTO c_emotes VALUES (';-)', 'emotes/wink.gif'); INSERT INTO c_emotes VALUES (':-P', 'emotes/tounge.gif'); INSERT INTO c_emotes VALUES (':-(', 'emotes/sad.gif'); Anyone see the problem??
"What is a dreamer that cannot persevere?" -- http://www.melchior.us
|
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
