What does this mean?

mccwd

Column count doesn't match value count at row 1
im a complete PHP/MySQL noob the scrit is to add several enteries to various tables.

leatherback

Hi,

it means that you are trying to insert values into a table, but the number of values you try to insert for that specific record is not the same as the number of colums in the table.

You'd best define for each value toi insert, tino which column it should go:

insert into TABLE (columname, columname, columname) values (value, value, value)

Houdini

Your query has an unmatching set of values for the query,sometimes it could be a field like an id or uid. Here is an example.

$query = "INSERT INTO table (id, first_name, last_name)
   VALUES('','$_POST[first_name]','$_POST[last_name])";

That will work.

$query = "INSERT INTO table (first_name, last_name)
   VALUES('','$_POST[first_name]','$_POST[last_name])";

This will not

$query = "INSERT INTO table (id, first_name, last_name)
   VALUES('$_POST[first_name]','$_POST[last_name])";

Neither will this.

If you look close the second query doesn't work because there is an added value when all that was to be inserted into the table was two values and there are three. The third query won't work because you are wanting to insert 3 values but there are ony two the first name and the last name but not an id. Does that help