in reply to Error adding a record into a MySQL table: 'Unknown column ...'

You probably don't have a column named "EMPLOY.FIRST.NAME" in your EMPLOYEE table (Note the "EE" at the end of the table name)

By the way, it's probably not a good idea to use dots in column names at all, since they're already used to seperate schemas / tables / columns in SQL.

Also, one of your parameters contains an undefined value, and it's a really bad idea to just insert user input into your SQL, since that makes it really easy for someone to crash your query and/or run their own SQL queries (like "DROP TABLE employee". :-)

You should use placeholders and/or quote.

  • Comment on Re: Error adding a record into a MySQL table: 'Unknown column ...'