[PHP] Urgent - MySQL is not inserting the single quotes

2002-03-07 Thread Manisha
I am inserting into the table values with single Quote. 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. Any help

Re: [PHP] Urgent - MySQL is not inserting the single quotes

2002-03-07 Thread Analysis Solutions
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

Re: [PHP] Urgent - MySQL is not inserting the single quotes

2002-03-07 Thread Manisha
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

Re: [PHP] Urgent - MySQL is not inserting the single quotes

2002-03-07 Thread Analysis Solutions
On Fri, Mar 08, 2002 at 12:44:30PM +0800, Manisha wrote: thanks, you are right, gpc_magic_quotes of php.ini was off. Oh, so then in your script, you weren't using the addslashes() function. Personally, I prefer *magic_quotes to be off, allowing me to precisely control what I want to do with

Re: [PHP] Urgent - MySQL is not inserting the single quotes

2002-03-07 Thread Jason Wong
On Friday 08 March 2002 13:10, Analysis Solutions wrote: On Fri, Mar 08, 2002 at 12:44:30PM +0800, Manisha wrote: thanks, you are right, gpc_magic_quotes of php.ini was off. Oh, so then in your script, you weren't using the addslashes() function. Personally, I prefer *magic_quotes to be