Posts: 3,176
Name: Thierry
Location: I'm the uber Spaminator !
|
This means that you either are missing a column, or have too much columns specified in your query.
Looking at your query, it's obvious. You have a "SurveyId" field, that you are not indicating in your query.
You should erplace
PHP Code:
INSERT INTO Survey VALUES ('$Email','$Movies','$Score','$Score1','$Score2','$Score')
with
PHP Code:
INSERT INTO Survey (Email, Movies, Score, Score1, Score2, Score3) VALUES ('$Email','$Movies','$Score','$Score1','$Score2','$Score')
That way, you tell the DB which data goes in which columns.
If you left the definition out, it tries to put the first value in the first column.
__________________
Only a biker knows why a dog sticks his head out the window.
|