joecooper Posted March 28, 2006 Share Posted March 28, 2006 I have a feild in a database that is called "Bake & Method".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 ''Bake & Method', Weight, Standard_Price) VALUES ('', '2', '3', 'i have the code as:[code]"INSERT INTO Products (Product_Cat_ID, Name, Description, Picture, 'Bake & Method', Weight, Standard_Price) VALUES ('$product_cat_id', '$name', '$description', '$picture', '$bakemethod', '$weight', '$standardprice') "[/code]Why doesnt it accept it in the ' ' Quote Link to comment https://forums.phpfreaks.com/topic/6035-mysql-feild-with-spaces/ Share on other sites More sharing options...
ober Posted March 28, 2006 Share Posted March 28, 2006 First of all, using an ampersand in a fieldname is NOT a good idea. Talk about asking for trouble.Secondly, if Product_Cat_ID is an auto_increment field, you can leave it out entirely. It'll fill itself in. If it's not an auto_increment field and you've specified that it cannot be empty/null, it's not going to accept it. Quote Link to comment https://forums.phpfreaks.com/topic/6035-mysql-feild-with-spaces/#findComment-21715 Share on other sites More sharing options...
joecooper Posted March 28, 2006 Author Share Posted March 28, 2006 the product cat id is just a number from 1 to 8, as in catogory ID. Quote Link to comment https://forums.phpfreaks.com/topic/6035-mysql-feild-with-spaces/#findComment-21716 Share on other sites More sharing options...
ober Posted March 28, 2006 Share Posted March 28, 2006 Then why isn't something in the query?!?!? Quote Link to comment https://forums.phpfreaks.com/topic/6035-mysql-feild-with-spaces/#findComment-21718 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.