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 ' ' 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. 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. 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?!?!? Link to comment https://forums.phpfreaks.com/topic/6035-mysql-feild-with-spaces/#findComment-21718 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.