Jump to content

[SOLVED] MYSQL Syntax Error?


davidL

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.