PHP - MYSQL Error
Posted: Sun Jul 23, 2006 11:07 am
Hi,
I using PHP 4.4.2 and MySQL 4.1.20-community-nt with IIS 6 on windows 2003 server. When I try to insert a row through the PHP code into a mysql table I'm getting the following error in the webpage
"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 ''Quote')' at line 1"
If I use the select statement it's working properly but when I use insert it gives that error. Could anyone plase help me on this issue.
Thanks,
oliver.
I using PHP 4.4.2 and MySQL 4.1.20-community-nt with IIS 6 on windows 2003 server. When I try to insert a row through the PHP code into a mysql table I'm getting the following error in the webpage
"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 ''Quote')' at line 1"
If I use the select statement it's working properly but when I use insert it gives that error. Could anyone plase help me on this issue.
Thanks,
oliver.