Insert Statement not working -- dunno why

[stonefield25]

I have never used serialized variables before, but I have some arrays I wish to store. So, I serialized a bunch of variables and am attempting to store them in a database. However, it is not working--and I don't even know if it is because of the serialized variables. I can't figure it out. Here's what the query looks like with some values in it:

INSERT INTO quote(quoteID, Dbproduct, Product, Gauge, Color, FrontFinish,
BackFinish, Quantity, id, chosen, custID)
VALUES(null,
'a:4:{i:0;s:5:\"Box 1\";i:1;s:11:\"Light Maple\";i:2;s:2:\"XB\";i:3;s:14:\"Natural Cherry\";}',
'a:4:{i:0;s:4:\"Box1\";i:1;s:11:\"Light Maple\";i:2;s:2:\"XB\";i:3;s:14:\"Natural Cherry\";}',
'a:4:{i:0;s:4:\"3/16\";i:1;s:3:\"1/8\";i:2;s:4:\"3/16\";i:3;s:3:\"1/8\";}',
'a:4:{i:0;s:5:\"White\";i:1;s:10:\"Pure White\";i:2;s:5:\"Flint\";i:3;s:3:\"Fog\";}',
'a:4:{i:0;s:19:\"Marker Board Finish\";i:1;s:5:\"Pixel\";i:2;s:9:\"Sandstone\";i:3;s:6:\"Stucco\";}',
'a:4:{i:0;s:19:\"Marker Board Finish\";i:1;s:5:\"Pixel\";i:2;s:9:\"Sandstone\";i:3;s:10:\"Supermatte\";}',
'a:4:{i:0;s:1:\"3\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"5\";}',
3, 'quote', 6)

Here's what the table looks like:
mysql> describe quote;
+-------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default| Extra |
+-------------+----------------------+------+-----+---------+----------------+
| quoteID | int(10) unsigned | | PRI | NULL |auto_increment |
| Dbproduct | varchar(255) | | | | |
| Product | varchar(255) | | | | |
| Gauge | varchar(255) | | | | |
| Color | varchar(255) | | | | |
| FrontFinish | varchar(255) | | | | |
| BackFinish | varchar(255) | | | | |
| Quantity | varchar(255) | | | | |
| id | tinyint(3) unsigned | | | 0 | |
| chosen | varchar(5) | | | | |
| custID | smallint(5) unsigned | | | 0 | |
+-------------+----------------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

Any help on this would be greatly appreciated. I have tried running it directly in MySQL and it tells me I have an error near 'quote(quoteID, Dbproduct, Product, Gauge, Color, FrontFinish, but I don't see how something in there could be the problem.

[kevinsequeira]

print out the query , what does it look like ?

reg
kevin

[stonefield25]

I hope I understand your request correctly, if not, I apologize in advance . . . but, I guess I need to be more clear. My query in my PHP code is actually this:
$query = "INSERT INTO customer(custID, name, company, address1, address2, city, state, zip, ";
$query .= "areacode, phone, email, password, password_hint) ";
$query .= "VALUES(null, '$name', '$company', '$address1', '$address2', '$city', '$state', $zip, $areacode, ";
$query .= "$phone, '$email', '$cpass', '$passwordHint')";

I printed it to the browser and got what I posted in my first post above.

[stonefield25]

oops, just realized I posted the wrong PHP code. This is the correct one:

$query = "INSERT INTO quote(quoteID, Dbproduct, Product, Gauge, Color, FrontFinish, BackFinish, ";
$query .= "Quantity, id, chosen, custID) ";
$query .= "VALUES(null, '$Dbproduct', '$Product', '$Gauge', '$Color', '$FrontFinish', '$BackFinish', ";
$query .= "'$Quantity', $id, '$chosen', $custID)";

[stonefield25]

Well, I have now got it to work, but I still don't know what the problem was. I just changed my query to not include the field names. So, it is now "INSERT INTO quote VALUES(null, . . . "

Does anybody have any ideas why this is?