unknown column

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
michaelk46
Forum Commoner
Posts: 67
Joined: Mon Oct 12, 2009 9:50 pm

unknown column

Post by michaelk46 »

Anyone know why I get Error: Unknown column 'caption3' in 'field list'

when I run this
INSERT INTO pages (retailprice, salesprice, upc, sku, categoryid, manufactureid, caption, pagename) VALUES (11.11, 1.01, 12345678901, 1234567, 8, 4, caption3, pagename3);

Here is what the columns look like in the table...
Image
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: unknown column

Post by Christopher »

You need to put quotes around "caption3" and "pagename3".
(#10850)
michaelk46
Forum Commoner
Posts: 67
Joined: Mon Oct 12, 2009 9:50 pm

Re: unknown column

Post by michaelk46 »

Thanks for the help... It's fixed
Post Reply