brianmay Posted October 27, 2008 Share Posted October 27, 2008 Hello guys, MySQL returns the following error: MySQL said: Documentation #1064 - 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 'WHERE sid='x'' at line 1 Note: x is a variable, in this case was 6 The syntax I'm using is: UPDATE ".$prefix."_specials SET stitle='$stitle', simg='$simg', sband='$sband', stxt='$stxt', WHERE sid='$sid' Quote Link to comment https://forums.phpfreaks.com/topic/130355-solved-error-1064-sqlstate-42000-er_parse_error/ Share on other sites More sharing options...
PFMaBiSmAd Posted October 27, 2008 Share Posted October 27, 2008 There is an extra comma right before the WHERE Quote Link to comment https://forums.phpfreaks.com/topic/130355-solved-error-1064-sqlstate-42000-er_parse_error/#findComment-676154 Share on other sites More sharing options...
brianmay Posted October 27, 2008 Author Share Posted October 27, 2008 Woops! Yes, it does work now! Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/130355-solved-error-1064-sqlstate-42000-er_parse_error/#findComment-676157 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.