php/mySQL error...

[GSXdan]

I am getting this error when running my address book script(see below):

Column count doesn't match value count at row 1

I have 6 tables in my mySQL database: master_name, address, telephone, fax, email, and personal_notes. When running the script, the first and last name will be entered into the database, but nothing else will. Sorry i dont have it working online, I cant figure out how to connect to my mySQL database on netfirms Let me know if you need any other info.

Thanks ^dan

[mairving]

That error is caused because you are posting too few values for the columns. For instance, if you have 8 columns in your table and you only insert 7 and don't tell MySQL that, you will get this error.

I generally always like to specify what data is going in what column. It makes sure that the right data goes into the right column and you can avoid things like this. Something like so:

Old Code:

PHP Code:

$add_address = "INSERT INTO address VALUES ('', $master_id,
                             now(), now(), '$_POST[address]', '$_POST[city]',
                             '$_POST[state]', '$_POST[zipcode]', '$_POST[add_type]')"; 


New Code:

PHP Code:

$add_address = "INSERT INTO address ";
$add_address .= "(fieldname1, fieldname2, fieldname3, fieldname4, ";
$add_address .= "fieldname5, fieldname6, fieldname7, fieldname8) ";
$add_address .= "VALUES ('', $master_id, now(), now(), ";
$add_address .= "'$_POST[address]', '$_POST[city]', ";
$add_address .= "'$_POST[state]', '$_POST[zipcode]', '$_POST[add_type]')"; 


Note that if you have an auto_increment field in fieldname1 instead of having a blank value, you can just bypass the value like so:

PHP Code:

$add_address = "INSERT INTO address ";
$add_address .= "(fieldname2, fieldname3, fieldname4, ";
$add_address .= "fieldname5, fieldname6, fieldname7, fieldname8) ";
$add_address .= "VALUES ($master_id, now(), now(), ";
$add_address .= "'$_POST[address]', '$_POST[city]', ";
$add_address .= "'$_POST[state]', '$_POST[zipcode]', '$_POST[add_type]')"; 


I also concatenated the add_address variable to make it more readable.