Reply to thread

Message

<blockquote data-quote="cammy" data-source="post: 449042" data-attributes="member: 46853">Ok so you have your furniture table and it looks like this...(EXAMPLE)id&nbsp;&nbsp; item_name&nbsp;&nbsp; public_name&nbsp;&nbsp; width&nbsp;&nbsp; length&nbsp;&nbsp; height&nbsp;&nbsp; sprite1&nbsp; &nbsp; duck&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Rubber Duck&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1You try running a query like such...INSERT INTO `furniture` VALUES ('2', 'throne', 'Throne', '1', '1', '1');It returns the error that the column count doesn't match...You then realise that it's missing data for one of the columns and fix it.INSERT INTO `furniture` VALUES ('2', 'throne', 'Throne', '1', '1', '1', '2');You run it and it works.-If you could provide your table structure and the SQL's your trying to add I'll explain what's missing.</blockquote>

[QUOTE="cammy, post: 449042, member: 46853"] Ok so you have your furniture table and it looks like this... (EXAMPLE) id item_name public_name width length height sprite 1 duck Rubber Duck 1 1 1 1 You try running a query like such... INSERT INTO `furniture` VALUES ('2', 'throne', 'Throne', '1', '1', '1'); It returns the error that the column count doesn't match... You then realise that it's missing data for one of the columns and fix it. INSERT INTO `furniture` VALUES ('2', 'throne', 'Throne', '1', '1', '1', '2'); You run it and it works. - If you could provide your table structure and the SQL's your trying to add I'll explain what's missing. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members