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:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to