Stupid MySQL Error

[Napster]

I am getting this mysql_error from my code which I have never seen before...

Column count doesn't match value count at row 1

from this code

mysql_query("INSERT INTO orders VALUES('',$customer_id,'$name','$company','$address','$address2','$city','$zipcoun[1]','$state','$country','$phone','$email','2','$ShipName','$ShipCompany','$ShipAddress','$ShipAddress2','$ShipCity','$ShipZip','$ShipState','$country','2','$name','$company','$address','$address2','$city','$zipcoun[1]','$state','$country','2','Credit Card','$paytype','$noc','$cnumber','$cexipires',NULL,now(),'1',NULL,'USD','1','$cvv','$ShipPhone','$ShipEmail')") or die (mysql_error());

No row is called count. And it just seemed to stop working without my doing anything to it. What is causing it?

[niroshan]

Hi,
just check the values that ur inserting against ur table columns. If u can post the table structure of the orders table it`ll b really help..

Regards,
Niroshan

[weekender]

The sql syntax is wrong - it's not that it thinks there is a column called 'count', it's that the number of columns in your sql is not equal to the number of values in your sql

your sql should follow the format

INSERT INTO `tablename` (`field1`, `field2`) VALUES ('value1', 'value2')

but your sql is completely missing the list of field names

adam