Error when sending info to MySQL database

bellaso

I am getting the following error when I submit my form in my PHP file:

Database Class: MySQL Error: Column count doesn't match value count at row 1

I understand that this problem is related to the number of columns in my database table, but I have double checked everything and I cannot find the problem. I have already made some adjustments to my PHP file such as:

      <input name="id" type="hidden" id="id"
      value="<?php echo $delmar->id; ?>">

Any help would be great. Thanks in advance!!!

xblue

without seeing your query I can only guess ...

a common misunderstanding I think is something like

INSERT INTO table_name (id, field2, field3) VALUES ('something', 'something else')

where you list all column names, but not enough values for them, maybe because id is autoincrement, so you don't know it. then the query should be:

INSERT INTO table_name (field2, field3) VALUES ('something', 'something else')
(no id field in the list of column names)

bogu

Tell me what ius your number of fields in your table and your INSERT sintax.

bellaso

The problem I am having is the info that is being added to the database is the info that is being filled out on a form. I am not going directly into the database and doing it myself, it is being done automatically through my form.

I have 23 columns in my table, that is including my auto_incrementing id. And I have 23 fields in my form, including on hidden field for my auto_incrementing id.

This is the code in my PHP file for my text fields:

    <div class="formHeader" id="formLeft">Title:</div>
    <div id="formRight">
      <input name="title" type="text"
      value="<?php echo $delmar->title; ?>" size="40" maxlength="150">
    </div>

This is the code in my PHP file for my hidden field:

Let me know if you need anymore info.
Thanks a lot for your help!!!

bogu

Tell me how many fields have your table and your INSERT sintax

bellaso

I have 23 fields in my table.

I'm not sure what you mean by "INSERT sintax".

Thanks!!

bogu

NOT RECORDS FIELS NUMBER AND "INSERT QUERY"

bogu

NOT RECORDS, BUT FIELDS NUMBER, AND "INSERT QUERY"