Mysql error

[Dakkar]

I have imported an sql file into mysql which include 3 tables like this
accounts
acc_tmp
queue

then i wanted to insert values into accounts table and write this lines

insert into accounts values('Dakkar','dakkar','Dakkar Osman','','','[e-mail]');

but it didnt work and gave this error
Column count doesnt match value count at row 1

How can i fix it?

[yousaf931]

Ur query is worng

It should be

$query_add="
INSERT INTO tablename
(field1, field2,field3,fieldn)
VALUES
('', '$value2',, '$value3', '$valueN')

";

Note : ' ' Field is auto increment.
You cant use more than one auto increment filed in a database.

Cheers,
yousaf FAYYAZ

[cosminb]

The error message says that the number of values that you want to insert si different from the number of fields from your table.

Find some MySQL documentation for more information

[Dakkar]

Thanks i fixed it now its working