Re: Urgent - MySQL is not inserting the single quotes

Hi Manisha: > If I give the command through text file - Insert into test values > ('manisha\' test') - then this is ok, but when i try to insert the > manisha ' test value through > http://<hostname>/sqladmin using GUI then > MySql is giving error. What's the error? That would certainly help us help you. It might even help you help yourself. I'm guessing that your php.ini file has gpc_magic_quotes on. If so, don't manually escape the data you're submitting, since PHP does it automatically. > Any body knows how to stop and start the MySql service ? Depends. Do you have control over the server? If so... net stop mysqld may do the trick for you. Later, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y