Re: [PHP] Escape problems...why?

2004-04-23 Thread Jason Wong
On Friday 23 April 2004 12:21, Ryan A wrote: But then am getting a 500 error... What does the webserver log say? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development *

Re: [PHP] Escape problems...why?

2004-04-23 Thread Marek Kilimajer
Ryan A wrote: Hey John, Thanks for replying. I cant use strip slashes because there are a number of scripts doing DB things and searching for all of them and modifying things just for one client can be a royal PITA. I tried to use php_flag magic_quotes_gpc off in the *existing* .htaccess file like

[PHP] Escape problems...why?

2004-04-22 Thread Ryan A
Hi, I am accepting some SQL via a textarea on a webform and then saving that SQL in the database for later use everythings working fine on our test servers but for some reason on our clients servers its screwing up. For example this insert statement: insert into test_ing

Re: [PHP] Escape problems...why?

2004-04-22 Thread John W. Holmes
Ryan A wrote: For example this insert statement: insert into test_ing values('a','a','a','a') becomes: insert into test_ing values (\'a\',\'a\',\'a\',\'a\') I immediatly suspected magic_quotes but checked (via phpinfo) and see that magic_quotes are off, as a safety precaution I even have

Re: [PHP] Escape problems...why?

2004-04-22 Thread Ryan A
Hey John, Thanks for replying. I cant use strip slashes because there are a number of scripts doing DB things and searching for all of them and modifying things just for one client can be a royal PITA. I tried to use php_flag magic_quotes_gpc off in the *existing* .htaccess file like so: