alena1347 Posted February 7, 2013 Share Posted February 7, 2013 I have a data base that updates the photo 1) A error occurs everytime i update the database error:- Error in Query: 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 '\0JFIF\0\0`\0`\0\0ÿÛ\0C\0 ' at line 3 code:- $sql = "UPDATE freelancer SET image=$imgData, name='{$_FILES['image']['name']} WHERE id=$in"; here $imgData is image with slashes 2) this is the error for Error in Query: 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 ''image-04.jpg WHERE id=29' at line 3 code:- $sql = "UPDATE freelancer SET image='$imgData', name='{$_FILES['image']['name']} WHERE id=$in"; please help for the error Link to comment https://forums.phpfreaks.com/topic/274144-error-in-update-query/ Share on other sites More sharing options...
Barand Posted February 7, 2013 Share Posted February 7, 2013 no closing quote after the image name Link to comment https://forums.phpfreaks.com/topic/274144-error-in-update-query/#findComment-1410718 Share on other sites More sharing options...
alena1347 Posted March 15, 2013 Author Share Posted March 15, 2013 On 2/7/2013 at 11:48 AM, Barand said: no closing quote after the image name ok Link to comment https://forums.phpfreaks.com/topic/274144-error-in-update-query/#findComment-1418779 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.