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..... Quote Link to comment 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')"; Quote Link to comment 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 Quote Link to comment 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')"; Quote Link to comment Share on other sites More sharing options...
nojhere Posted November 2, 2009 Author Share Posted November 2, 2009 Still occur the same error... Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted November 2, 2009 Share Posted November 2, 2009 INSERT queries DON'T have WHERE clauses. Quote Link to comment 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? Quote Link to comment 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}"; Quote Link to comment 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... Quote Link to comment 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. Quote Link to comment 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... Quote Link to comment 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. Quote Link to comment 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.