MySQL problem

[Anon]

Hello
I receive this error message:
ERROR: Column count doesn't match value count at row 1
but I don't have any columns named count.
Can anybody saywhat it is I'm missing?

Thanks
/babak

[Anon]

show us the query please...

[Anon]

This usually means e.g.

insert into tablename (id1, id2, id3) values ('1', '2', '3', '4');

note I am trying to add 4 values into only 3 fields, there fore "Column count doesn't match value count" - nothing to do with a field named count.

Hope this helps...

Darren

Babak wrote:

Hello
I receive this error message:
ERROR: Column count doesn't match value count at row 1
but I don't have any columns named count.
Can anybody saywhat it is I'm missing?

Thanks
/babak

[Anon]

This error means you have a query with several columns named and a different number of values specified in the query. For example, the following query would give that error because three columns are listed but four values are given:

insert into table (name,address,phone) values ("Mike","Main Street","2222222222","Hello");

That's it!!

Just check the number of fields you have listed (count) and compare that with the number of values and you'll see the problem.

[Anon]

Yes it worked
Thanks a lot to you all. It was a mismatch between the number of arguments and the values.
Thanks you very very much.