in reply to Error adding a record into a MySQL table: 'Unknown column ...'
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.
|
|---|