galvin Posted December 21, 2008 Share Posted December 21, 2008 Can anyone tell me why I'm getting the message "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 ''0-01c6ssob04iun9p3alqlq41584.jpg', caption= 'This is some text Im trying to upd' at line 1" for the following query... $query = "UPDATE captions SET image '" . $file1name . "', caption= '" . $_POST['caption1'] . "' WHERE image = '" . $file1name . "'"; It's probably something simple with single or double quotes, but I cant figure it out. Quote Link to comment https://forums.phpfreaks.com/topic/137914-solved-help-with-query-syntax/ Share on other sites More sharing options...
RussellReal Posted December 21, 2008 Share Posted December 21, 2008 $query = "UPDATE captions SET `image` = '{$file1name}', `caption` = '{$_POST['caption1']}' WHERE `image` = '{$file1name}'"; Quote Link to comment https://forums.phpfreaks.com/topic/137914-solved-help-with-query-syntax/#findComment-720817 Share on other sites More sharing options...
galvin Posted December 21, 2008 Author Share Posted December 21, 2008 Thanks Russell, that did it!! Quote Link to comment https://forums.phpfreaks.com/topic/137914-solved-help-with-query-syntax/#findComment-720821 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.