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? 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` 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` Link to comment https://forums.phpfreaks.com/topic/154527-solved-mysql-syntax-error/#findComment-812469 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.