davidL Posted April 17, 2009 Share Posted April 17, 2009 Hey anyone who can help me! I am not exactly new to mysql but very far from a steady user. I am trying to Insert a simple form into a table and I keep getting errors, $sql="INSERT INTO inventory (design, sizes, colors, desc, image1url, thmbimage1url, image2url, thmbimage2url, image3url, thmbimage3url, image4url, thmbimage4url)". "VALUES ('$design', '$sizes', '$colors', '$desc', '$image1_url', '$thmb_image1_url', '$image2_url', '$thmb_image2_url', '$image3_url', '$thmb_image3_url', '$image4_url', '$thmb_image4_url')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); This keep coming up with this Error: " Error: 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 'desc, image1url, thmbimage1url, image2url, thmbimage2url, image3url, thmbimage3u' at line 1 " I've been looking over the code for the last 3 hours and I can't find my mistake.. ANY HELP? Quote Link to comment https://forums.phpfreaks.com/topic/154527-solved-mysql-syntax-error/ Share on other sites More sharing options...
Maq Posted April 17, 2009 Share Posted April 17, 2009 I think desc is a reserved word. Put backticks around it. `desc` Quote Link to comment https://forums.phpfreaks.com/topic/154527-solved-mysql-syntax-error/#findComment-812462 Share on other sites More sharing options...
davidL Posted April 17, 2009 Author Share Posted April 17, 2009 YOU ARE THE SMARTEST!! Thank you so much I think desc is a reserved word. Put backticks around it. `desc` I think desc is a reserved word. Put backticks around it. `desc` Quote Link to comment https://forums.phpfreaks.com/topic/154527-solved-mysql-syntax-error/#findComment-812469 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.