get.Mos
4-8-03, 04:40 PM
hello, i have a question... i'm trying to have a script enter data from a form into a mysql db. i'm pretty sure i've implemented the script correctly, and the form is fine as well, however, i'm getting the following sql error:
!! Oops !!
SQL error Cannot insert item: Column count doesn't match value count at row 1
(the above error message was generated by the script, if i'm not mistaken, so i'm pretty sure i have that part ok)
does anyone have any ideas as to where i should begin troubleshooting this? it sounds like the number of fields in the table in the db don't match the number of fields in the form?
i used mysql front to add a table to my db; do i need to insert a primary key into the table, even though the form does not have that field?
any advice is greatly appreciated.
!! Oops !!
SQL error Cannot insert item: Column count doesn't match value count at row 1
(the above error message was generated by the script, if i'm not mistaken, so i'm pretty sure i have that part ok)
does anyone have any ideas as to where i should begin troubleshooting this? it sounds like the number of fields in the table in the db don't match the number of fields in the form?
i used mysql front to add a table to my db; do i need to insert a primary key into the table, even though the form does not have that field?
any advice is greatly appreciated.