Re: Urgent - MySQL is not inserting the single quotes

thanks, you are right, gpc_magic_quotes of php.ini was off. At 11:08 PM 3/7/02 -0500, Analysis & Solutions wrote:

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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php