+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: You have an error in your SQL syntax; check the manual that corresponds to your MySQL etc (/showthread.php?tid=46110)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL etc - El Forum - 10-18-2011
[eluser]ozstar[/eluser]
Hi,
I have a script made with codeigniter which did work in 2009 but it seems with mySQL updates it may need some tweeking.
It seems most of the scriptsworks however when one tries to enter an amount in their account, the message comes up.
This is the message I get. I understand that without the files it maye be hard or impossible to know what is happening however maybe I can get a pointer or two.
The html page this is on, points to...
<form action="/wap/userinfo.php" method="POST">
so not sure if userinfo.php is the script where the problem may lay.
Appreciate any help. BTW The CC details are fake.
oz
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 ''Mastercard;5353765423451144;02/15;10;John Doe;','10')' at line 1QUERY:::INSERT INTO ttransaction (ttype,tdate,tuser,tsubject,tsum) VALUES(2,'2011-10-19 08:34:32',,'Mastercard;5353765423451144;02/15;10;John Doe;','10')