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?

you have comment out // mysql_real_escape_string($image), your query waits 9 variables you pass it 8 — afarazit
– afarazit, Commented May 9, 2011 at 2:32
I am going to be uploading the image another way. The image key is in the table, but a value is not being inserted for it. Could this be a cause? — max_
– max_, Commented May 9, 2011 at 2:33

Ignacio Vazquez-Abrams · Accepted Answer · 2011-05-09 02:31:25Z

84

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

answered May 9, 2011 at 2:31

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ignacio Vazquez-Abrams Over a year ago

Then you didn't fix the problem. Because that is the problem.

Dharman · Accepted Answer · 2021-02-15 21:11:12Z

13

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')

edited Feb 15, 2021 at 21:11

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

answered May 9, 2011 at 2:34

Tharsan

1,0251 gold badge7 silver badges19 bronze badges

1 Comment

Ignacio Vazquez-Abrams Over a year ago

Except all the fields are off by one now.

Sebass van Boxel · Accepted Answer · 2012-10-01 17:42:03Z

6

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.

edited Oct 1, 2012 at 17:42

Sebass van Boxel

2,6221 gold badge24 silver badges37 bronze badges

answered Oct 1, 2012 at 16:48

MCForty

611 silver badge1 bronze badge

1 Comment

fancyPants Over a year ago

Please note that this question has already been answered. No need to revive a 1.5 year old post unless you can add something new. Thanks for your effort anyway.

Collectives™ on Stack Overflow

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

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related