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

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']) . ');
 
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: unknown column

Post by AbraCadaver »

Quote your string values, and delete your other post!
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Post Reply