ERRORColumn count doesn't match value count at row

[Yugiohwiz]

ERRORColumn count doesn't match value count at row 1 I have this error how do I fix it

[aspnetguy]

what is your table structure??? What is the query you are using???

[Jack McKalling]

As for the INSERT query, keep in mind it needs for both columns and values the same amount of fields.

INSERT INTO table (column1,column2,column3) VALUES ('value1','value2','value3')

You may have forgotton to specify the columns, when you did not had a value for all the collumns. There are four rules for the INSERT query:-Values must be in the same order as the column names.-A partly column list is allowed-A columnlist is not prohibited-The columnlist and the values list must be in the same length