Column Count doesnt match value count

[digitman]

Hi.
I have about 60 or more fields in my table,and I cant fill in all of them at the same time.E.g sometimes the user only fills in 20,or even 2.My problem here is that whenever I try to fill the table with the values(less than 60) it gives me the Column Count doesnt match value count at row 1 error.I have a field set as auto_increment and I use blank quotes('') to add to that field.But it still gives me the error.I have the fields set as NULL and their type as int in my table,could that be the problem?
thx.

[digitman]

anybody?this is urgent...

[digitman]

I changed the properties of all the fields from NULL to NOT_NULL but it still doesnt seem to work.Here is the query that I'm trying to make:

INSERT INTO table1 VALUES ('',1,11,12,13,2,21,22,23,3,31,32,33)

All of the fields in my table are of int type.
Can someone please tell me what I'm doing wrong?

[Lats]

You've got to be specific on what's going into the table, fieldnames & values. Here's a snippet from a 'simple' news script...

    $sql = "
    INSERT INTO
        the_news
    SET
        date_posted = now(),
        event_region = '$_POST[posted_region]',
        event_type = 'news',
        event_start = '$_POST[event_start]',
        event_end = '$_POST[event_end]',
        is_announcement = '$_POST[news_announcement]',
        news_title = '$_POST[news_title]',
        news_details = '$_POST[news_detail]',
        news_notes = '$_POST[news_notes]',
        approved = '$_POST[approved]',
        display_after = '$_POST[show_after]'
        "; 

You'll need to do something similar.

[digitman]

Hi.
Nothing specific is going on in the table.Just about 60 fields,each of them is of int type and their maximum length is 6.and they're set to NOT NULL.thats all!

[Lats]

Yep, I think you may have missed my point - you need to set the field values according to the input values.

Example, field_15 can only accept values from the 15th input statement on your form, field_16 can only accept values from the 16th input statement etc etc.

Your table is expecting 60 values, so you need to give it either all 60 values, or specify the fieldnames like the example in my previous post.

[digitman]

Aah i got it.thanks bro.Lemme try it.

[digitman]

One more question,what should I set the auto incrementing field of the table as?Should I just specify no value for it and it would increment by itself?

[Lats]

No value for auto_increment is good

[digitman]

thx,just wanted to confirm