mysql error number 1064
Hi,
Recently i have migrated my db from access to mysql. Iam using front end php and connecting DB mysql. while i am using some insert query i am getting the following error...."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 ''LastName','FirstName','NetId','StaffNo','Phone','Initials','PM','FAC','PF','KRE' at line 1".
I am using insert query like this...
insert into tblresource ('LastName','FirstName','NetId','StaffNo','Phone','Initials')
values ('ram','erukula','cg123','ac123','1234','re');
Please help me in this issue. I am new to mysql...
Thanks,
Ramesh