PHP/MySQL Question?

Question

What does the following mean when displayed on the screen?

And what are some solutions to correct it?

Column count doesn't match value count at row 1

Code I think is giving me a problem.

$query2 = "INSERT INTO question_tags (tag_id, users_questions_id) VALUES ('$id',(SELECT id FROM tags WHERE tag='" . $tags[$x] . "'), '$page')";

I removed the $id and now I get the following error.

Column 'tag_id' cannot be null

Answer 1

Check this out http://htmlfixit.com/cgi-tutes/tutorial_MySQL_Error_Invalid_Query_Column_Count_Does_Not_Match_Value_Count.php

Answer 2

In your query you are specifying 2 columns in the columnslist but then providing 3 values in the value list. Either provide a third column name or remove on the values.

Answer 3

Your column list (tag_id, users_questions_id) has two items. Your values list ('$id',(SELECT id FROM tags WHERE tag='" . $tags[$x] . "'), '$page') has three.