Mysql syntax error server version

Question

Error

INSERT INTO PENILAIAN (ID,KURSUSID,QUEST1,QUEST2,QUEST3,QUEST4,QUEST5,QUEST6,QUEST7,QUEST8,QUEST9,QUEST10)VALUES ('951019105851', ''13'', '1', '2', '3', '4', '4', '5', '4', '5', '4', '5')

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 '13'', '1', '2', '3', '4', '4', '5', '4', '5', '4', '5')' at line 3

code

"INSERT INTO PENILAIAN (ID,KURSUSID,QUEST1,QUEST2,QUEST3,QUEST4,QUEST5,QUEST6,QUEST7,QUEST8,QUEST9,QUEST10)VALUES
('$login_sessionID',
'$kid','$QUEST1','$QUEST2','$QUEST3','$QUEST4','$QUEST5','$QUEST6','$QUEST7','$QUEST8','$QUEST9','$QUEST10')";

('951019105851', ''13'', note the double single quote. Apparently , you already quoted the $kid variable — Raphioly-San
– Raphioly-San, Commented Jan 11, 2016 at 12:30

Abdulla Nilam · Accepted Answer · 2016-01-11 12:31:37Z

1

Error simply guides you

''13''
 ^  ^

there is additional single quote

keep only one ' pair for code
Use prepared statements

answered Jan 11, 2016 at 12:31

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abdulla Nilam Over a year ago

Happy to help :)

Rafael · Accepted Answer · 2016-01-11 12:32:52Z

0

I think you have double quotes on ''13''. olso i want to ask, does any of the values contain quotes? like this (I'am x) if you use quotes you should use mysql_real_escape_string when you POST

answered Jan 11, 2016 at 12:32

Rafael

99 bronze badges

Collectives™ on Stack Overflow

Mysql syntax error server version

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related