Page 1 of 1

unknown column

Posted: Mon Jan 11, 2010 1:57 pm
by michaelk46
Anyone know why I get Error: Unknown column 'caption3' in 'field list'

when I run this

Code: Select all

 
INSERT INTO pages (retailprice, salesprice, upc, sku, categoryid, manufactureid, caption, pagename) 
VALUES (' . ($row['retailprice']) . ', ' . ($row['salesprice']) . ', ' . ($row['upc']) . ', ' . ($row['sku']) . ', ' . $catid . ', ' . $manuid . ', 
' . ($row['caption']) . ', ' . ($row['pagename']) . ');
 

Re: unknown column

Posted: Mon Jan 11, 2010 2:11 pm
by AbraCadaver
Quote your string values, and delete your other post!