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. 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}'"; 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!! 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
Archived
This topic is now archived and is closed to further replies.