RE: [PHP-DB] Unknown column 'Test' in 'field list'

Even though this is solved, I should mention a method that I find to be personally easier to use when INSERTing records. Simply use the field=value method: INSERT INTO MyTable SET firstname='Joe', lastname='Bob', age=58; By doing it this way, you don't have to worry about matching up the number of columns to values, or the order of the fields (the above example could have age or lastname as the first value without changing the output). Not to mention this method is a little easier to read and easier to construct. - Jonathan -----Original Message----- From: Jennifer Downey [mailto:jendowney@attbi.com] Sent: Thursday, March 28, 2002 6:55 PM To: php-db@lists.php.net Subject: [PHP-DB] Unknown column 'Test' in 'field list' Never mind I forgot to put ' ' around $u_name in my insert. Jen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php