whizzykid Posted August 8, 2009 Share Posted August 8, 2009 I am getting this error all the time. 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 '(`Account name`, `Account Number`, `Available balance`, `Country of Transfer`, `' at line 1 This is the code. $updateSQL = sprintf("UPDATE account1(`Account name`, `Account Number`, `Available balance`, `Country of Transfer`, `Country of Destination`, `Account Activation Fee`) VALUES (%s, %s, %s, %s, %s, %s)", Link to comment https://forums.phpfreaks.com/topic/169328-help-needed/ Share on other sites More sharing options...
trq Posted August 8, 2009 Share Posted August 8, 2009 can you echo $updateSQL and show us the output? Link to comment https://forums.phpfreaks.com/topic/169328-help-needed/#findComment-893509 Share on other sites More sharing options...
kartul Posted August 8, 2009 Share Posted August 8, 2009 http://dev.mysql.com/doc/refman/5.0/en/update.html should be: UPDATE account1 SET `Account name`= '%s', `Account number`= '%s' WHERE `something`='something' Link to comment https://forums.phpfreaks.com/topic/169328-help-needed/#findComment-893525 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.