Help a newbie!!!!

[gezzam]

Hi all,

I am attempting to insert data into a MySQL database from a form using the following code (it is from a textbook but I have modified it a little) and I get the following error :

MySQL error: 1136 : Column count doesn't match value count at row 1 (# 256).

$query = "INSERT INTO customer VALUES (NULL, " .
"\"" . $formVars["surname"] . "\", " .
"\"" . $formVars["firstName"] . "\", " .

"\"" . $formVars["title"] . "\", " .
"\"" . $formVars["address1"] . "\", " .
"\"" . $formVars["address2"] . "\", " .
"\"" . $formVars["city"] . "\", " .
"\"" . $formVars["zipcode"] . "\", " .
"\"" . $formVars["phone"] . "\", " .
"\"" . $formVars["fax"] . "\", " .
"\"" . $formVars["email"] . "\", " .
0 . ")";

No matter how much I play with it I can't get it to work.....please help old dumbo here.....:rolleyes:

[laserlight]

Check your table columns.

Do they correspond?

[gezzam]

Yes they do.....i think it has something to do with that last line...

[m_tt]

You should always be as specific as possible with SQL queries. It is hard to tell, but just like the error says, your column count doesn't match the query.

Format the query like this and you will probably see the problem right away:

INSERT INTO customers (`ID`,`FirstName`,`LastName`) VALUES ('','" . $firstName . '",'" . $lastName . "');