Date: 11/05/07 (PHP Community)    Keywords: php, mysql, sql, google

I've already scoured google in relation to this issue and so far have found many solutions, none of which seems to work.

PHP 4
MySQL 4.1.20

The script I'm working on at the moment returns a MySQL error : Unknown column 'column_name' in 'field list' Where column_name can be any valid column for the table. I've changed the order and the query insert style several times, restarted the MySQL server, and various other rain dances, all with the same results.

Here's a brief overview of the query that the script generates, it works fine when run directly in MySQL so I'm guessing there's something funny going on with the PHP/MySQL interface.


INSERT INTO table (area, type, city, state, cost, status, capacity, allowed, description, link, startdate, regclose, enddate, over18, gender, level1, level2, level3) VALUES ('East', 'eryery', 'sdfaf', 'CA', '1', 'C', '1', 'N', 'ewt', 'yerr', '2007-05-04 01:00:00', '2010-01-01 01:00:00', '2011-01-01 01:00:00', '1', 'M', '1', '1', '1')Error in query: INSERT INTO table (area, type, city, state, cost, status, capacity, allowed, description, link, startdate, regclose, enddate, over18, gender, level1, level2, level3) VALUES ('East', 'eryery', 'sdfaf', 'CO', '1', 'C', '1', 'N', 'ewt', 'yerr', '2007-05-04 01:00:00', '2010-01-01 01:00:00', '2011-01-01 01:00:00', '1', 'M', '1', '1', '1'). Unknown column 'area' in 'field list'


Any ideas anyone? I generally try and hammer these things out on my own but this one's just too busy givnig me a migraine after working on it for so long. Still with no idea how to start on it.

Source: http://community.livejournal.com/php/594338.html