PHP MySQL error Column count doesn t match value count at row 1

Question

I m getting this error   Column count doesn t match value count at row 1  From the following code    name     GET  name     description     GET  description     shortDescription     GET  shortDescription     ingredients     GET  ingredients     method     GET  method       image     GET  image     username     GET  username     length     GET  length     dateAdded   uk date     conn   mysql connect  localhost    dbname    pass    mysql select db  dbname     query   sprintf  INSERT INTO dbname  id  Name  Description  shortDescription  Ingredients  Method  Length  dateAdded  Username  VALUES        s     s     s     s     s     s     s         mysql real escape string  name       mysql real escape string  description       mysql real escape string  shortDescription       mysql real escape string  ingredients         mysql real escape string  image       mysql real escape string  length       mysql real escape string  dateAdded       mysql real escape string  username          result   mysql query  query  or die mysql error       What does the error mean

User · Answer

The number of column parameters in your insert query is 9, but you've only provided 8 values.

INSERT INTO dbname (id, Name, Description, shortDescription, Ingredients, Method, Length, dateAdded, Username) VALUES ('', '%s', '%s', '%s', '%s', '%s', '%s', '%s')

The query should omit the "id" parameter, because it is auto-generated (or should be anyway):

INSERT INTO dbname (Name, Description, shortDescription, Ingredients, Method, Length, dateAdded, Username) VALUES ('', '%s', '%s', '%s', '%s', '%s', '%s', '%s')

User · Answer

You have 9 fields listed  but only 8 values  Try adding the method

User · Answer

Your query has 8 or possibly even 9 variables  ie  Name  Description etc  But the values  these things ---        s     s     s     s     s     s     s     only total 7  the number of variables have to be the same as the values   I had the same problem but I figured it out  Hopefully it will also work for you

[php] PHP, MySQL error: Column count doesn't match value count at row 1

Examples related to php

Examples related to mysql