nojhere Posted November 2, 2009 Share Posted November 2, 2009 This is my code.. $sql = "INSERT INTO template (file,file_ext, file_size, file_data,tarikh_kemaskini) "; $sql.= "VALUES ("; $sql.= "'{$file}', '{$file_ext}', '{$file_size}', '{$file_data}','{CURDATE()}' WHERE id='$id'"; Error occur said like this : 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 id='1'' at line 1 The error maybe at WHERE id='$id'"; syntax and how to overcome this problem?? Help me..... Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/ Share on other sites More sharing options...
bubbasheeko Posted November 2, 2009 Share Posted November 2, 2009 Try this, you missed a bracket: $sql = "INSERT INTO template (file,file_ext, file_size, file_data,tarikh_kemaskini) "; $sql.= "VALUES ("; $sql.= "'{$file}', '{$file_ext}', '{$file_size}', '{$file_data}','{CURDATE()}' WHERE id='$id')"; Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949034 Share on other sites More sharing options...
nojhere Posted November 2, 2009 Author Share Posted November 2, 2009 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 id='1')' at line 1 Still error occur...huhu Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949038 Share on other sites More sharing options...
bubbasheeko Posted November 2, 2009 Share Posted November 2, 2009 Let's change the structure a bit. I don't think you require the {} around curdate(). $sql = "INSERT INTO `template` (`file`, `file_ext`, `file_size`, `file_data`, `tarikh_kemaskini`) "; $sql.= "VALUES ('{$file}', '{$file_ext}', '{$file_size}', '{$file_data}', CURDATE() WHERE id='$id')"; Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949046 Share on other sites More sharing options...
nojhere Posted November 2, 2009 Author Share Posted November 2, 2009 Still occur the same error... Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949063 Share on other sites More sharing options...
PFMaBiSmAd Posted November 2, 2009 Share Posted November 2, 2009 INSERT queries DON'T have WHERE clauses. Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949094 Share on other sites More sharing options...
nojhere Posted November 2, 2009 Author Share Posted November 2, 2009 I don't understand..huhu.. Can u make it clear what should i do? Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949113 Share on other sites More sharing options...
bubbasheeko Posted November 2, 2009 Share Posted November 2, 2009 OMG I missed that! WHERE id='$id' is not used when you use INSERT INTO. It is used for UPDATE and DELETE. If you are intending to update the record then you would use: $sql = "UPDATE `template` SET `file` = {$file}, `file_ext` = {$file_ext}, `file_size` = {$file_size}, `file_data` = {$file_data}, `tarikh_kemaskini` = CURDATE() WHERE `id` = {$id}"; Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949119 Share on other sites More sharing options...
nojhere Posted November 2, 2009 Author Share Posted November 2, 2009 OMG I missed that! WHERE id='$id' is not used when you use INSERT INTO. It is used for UPDATE and DELETE. If you are intending to update the record then you would use: $sql = "UPDATE `template` SET `file` = {$file}, `file_ext` = {$file_ext}, `file_size` = {$file_size}, `file_data` = {$file_data}, `tarikh_kemaskini` = CURDATE() WHERE `id` = {$id}"; Still the same error with this syntax : WHERE `id` = {$id}";... huhuhu... Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949167 Share on other sites More sharing options...
Philip Posted November 2, 2009 Share Posted November 2, 2009 $sql = "INSERT INTO `template` (`file`, `file_ext`, `file_size`, `file_data`, `tarikh_kemaskini`) "; $sql.= "VALUES ('{$file}', '{$file_ext}', '{$file_size}', '{$file_data}', CURDATE())"; echo $sql; Does that show what it should read? If so, copy/paste that here. Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949177 Share on other sites More sharing options...
nojhere Posted November 2, 2009 Author Share Posted November 2, 2009 That problem was already solve by me... But i get another problem with my blob data...huhu... Thanks for all of you for helping me... Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-949190 Share on other sites More sharing options...
fenway Posted November 14, 2009 Share Posted November 14, 2009 That problem was already solve by me... But i get another problem with my blob data...huhu... Thanks for all of you for helping me... I don't see any sql statements being echo'ed as requested. Link to comment https://forums.phpfreaks.com/topic/179903-somebodyi-need-some-help/#findComment-957445 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.