I get an error like this where it truncates the query
Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table employee (emp_fname, emp_lname, emp_id, emp_perm, emp_pas
at first it seemed to be cutting it where the line was wrapping but I tried turning wordwrap off and it still didn't work. Is this the kind of thing that something like mysql_escape_string would work on?
it looks like I spoke too soon. It seems to do the same thing. Here's the entire error
Array ( ) cannot insert record: insert into table employee (emp_fname, emp_lname, emp_id, emp_perm, emp_pass, emp_email) values ('Qndres', Swift, 'ahws123', '8', 'bdb123', 'd@b.com'). - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table employee (emp_fname, emp_lname, emp_id, emp_perm, em
One of the reasons for constructing the query like this, is that is is easy to see if you have forgotten a quote.
Also, any data that you enter into the database should be protected by the mysql_escape_string. This makes sure that if your data contains the quote character, it is correctly escaped.
don't forget that you might have a space at the end of your row's name. (like i did)
So when you created your table be sure there is nospace (it's sometimes hard to pin point)
if you have phpmyadmin , go look at your table and see if ll name have no spaces.