Column name or number of supplied values does not match table definition.
It errors out at line 29 (where I start to insert my data).
I've done some research and here's the closest reasoning to my issue that I've found: "The reason for this error is using table name as prefix of a column name and that table
name is not included in the from clause. Anothe reason is you may be assigning an alias to the table name and prefix is still the table name." Basically that I'm trying to insert more variables into the table than fields defined. If you have 4 fields
and you try to insert 5, you get the error. I'm declaring 10 fields and trying to insert 10...
I'm listing the columns that I'm trying to insert, declaring my variables, and inserting the data. Where am I going wrong? Any pointers would be much appreciated. Thanks