help!! please mysql...

[the apprentice webmaster]

i have this :

[b]INSERT INTO user
VALUES (

'localhost', 'toto', Password( 'password' ) , 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n'
);[/b]
looks fine to me but when i ran it i got this error :

[b]Error
SQL query:

INSERT INTO user
VALUES (

'localhost', 'toto', Password( 'password' ) , 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n'
);



MySQL said: 

#1136 - Column count doesn't match value count at row 1 [/b]

[neugi]

check if the amount of the y & n are correct, seems there is one more or less in your query.

best

[fenway]

Explicitly specify the column list, and you'll see that they don't match.

[the apprentice webmaster]

thx guys , but can you be more precise i am new at this ...
anyone please help

[wildteen88]

Basically check that you have 31 columns within your user table. And the values in your query match up to those columns

What I think fenway meant was to lists you columns in your query: eg:
[code]INSERT INTO user (col1, col2, col3, .. etc .. ) Values ('localhost', 'toto', .. etc ..)[/code]
Obvioulsy you'll want to change where it says colx - x being a number - to the actuall column name you have in your database.

[fenway]

Post the SHOW CREATE TABLE output so that I can see how many columns you're supposed to have.