Thanks for all the responses to my posting below. I was using phpmysqladmin to check on updating the database, and I finally figured out that phpmysqladmin was misconfigured, with the same database on two different servers but with different column names. Naturally I was sending the query to the database with the wrong column name, which is why I got the error. Once I figured it out (by command line calls to mysql), all was well. I appreciate the advice from the list and I've changed some of the column names as responders suggested to avoid other problems. So thanks much! Mike Kent The Indianapolis Star - Information Technology Internet mail: AOL messenger: mkent INI [EMAIL PROTECTED] ----- Forwarded by Mike Kent/INI on 08/07/01 01:42 PM ----- Mike Kent To: [EMAIL PROTECTED] 08/06/01 cc: 11:56 AM Subject: 1054 error I'm new to MySQL and I get a 1054 error on this SQL query sent by a PHP 4 script: 1054: Unknown column 'pricerange' in 'field list' $sql is INSERT INTO CCC_reviews (restname, type, specialties, address, phone, hours, pricerange, creditcards, reservations, rating, miscinfo, area, wheelchair, maplink, byline, date, reviewsum, review) VALUES ('Junkyard dog', 'Bakery', 'dogburgers', 'who cares', 'none', 'none', 'Moderate', 'Y', 'N', '1 1/2', 'Place stinks', 'North', 'N', 'somewhere', 'By Junkyard Bob', 'August 6, 2001', 'blah blah blah sum', 'blah blah blah real thing') The column pricerange does exist, and I've verified there's no trailing space or the like. Anyone know what's wrong? Thanks. Mike Kent The Indianapolis Star - Information Technology Internet mail: AOL messenger: mkent INI [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php