www.webdeveloper.com
Results 1 to 4 of 4

Thread: Error: Column count doesn't match value count at row 1 - I cannot find the problem.

  1. #1
    Join Date
    May 2013
    Posts
    8

    Error: Column count doesn't match value count at row 1 - I cannot find the problem.

    I have a large survey that submits the fields into a MySQL database.

    The survey form code is here
    http://michaeljbaran.com/surveyCode.html


    and my save-in-database18.php file looks like this - http://michaeljbaran.com/myPHPCode.html


    I have looked over the php file and the MySQL database for hours and hours and I still get the error*

    Column count doesn't match value count at row 1

    Here's a screen shot of the database structure. http://michaeljbaran.com/databaseStructure.jpg

    if anyone would like to try and help it would be greatly appreciated, thank you ahead of time.

  2. #2
    Join Date
    May 2013
    Posts
    8
    I must say, I'm not a pro at MySQL so if anyone suggests to do a "Run SQL query/queries" within phpMyAdmin please walk me through on exactly what I need to do, thank you.

  3. #3
    Join Date
    May 2013
    Posts
    8
    never mind, I fixed it. The field shopped_during_the_last_year_Heinens_of_Rocky_River was during_the_last_year_Heinens_of_Rocky_River in teh database, I adjusted the database to match the field but it still didn't work. With a little trial and error, with the php file including certain values I narrowed down the cause of the error and am now working on fixing it. The cause is the values that contain Specialty_Store

    I'll submit my findings when I fix it if I do.

  4. #4
    Join Date
    May 2013
    Posts
    8
    Good grief, I had 1 extra value in the php file. I removed it and now it works just fine.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles