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

2002-03-29 Thread Jonathan Hilgeman
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

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

2002-03-28 Thread David Christensen
Change your query to this and make sure your ID field is set to auto_increment INSERT INTO entry (user_name) values ('$name') That'll work for sure! ;-) Jennifer Downey wrote: Hi All! Hope I'm not bothering you nice people too much. I have a account called Test, when I click the