Unknown column 'CC028' in 'field list'

[mancroft]

I am using

$sql = ("insert into cart(cookieId, ITEMID, qty,COLOR,SIZE) values('" . GetCartId() . "', $ITEMID, $qty,$COLOR,$SIZE)") or die(mysql_error());

to insert values into a mysql database:

echo $sql;

gives:

insert into cart(cookieId, ITEMID, qty,COLOR,SIZE) values('ed5704bcd3c3f93bff52f59ae2057d02', 231513001, 1,CC028,L)Unknown column 'CC028' in 'field list'

What does Unknown column 'CC028' in 'field list'mean?

Thanks.

[mrhappiness]

this means that mysql searches for a colum with this name since you have to envelop it with ' if you want the string CC028 to be inserted

[mancroft]

Thanx, mrhappiness