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 Quote 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 Quote 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 no closing quote after the image name ok Quote Link to comment https://forums.phpfreaks.com/topic/274144-error-in-update-query/#findComment-1418779 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.