php script appends extra characters to query when deployed
Posted: Sun Aug 06, 2006 10:29 pm
Hi,
I have a php script that queries a database, When I deploy it locally in my server and I query with the following query:
Select * from patents where casename like '%microsoft%';
It works fine.
However when I deploy it to a remote hosted site, and I run the same query, It doesnt work, because it passes the following query:
Select * from patents where casename like \'%microsoft%\';
How do I remove those slasshes?? I even tried trimming the slashes in the string passed to the mysql server but it wont work.
I have a php script that queries a database, When I deploy it locally in my server and I query with the following query:
Select * from patents where casename like '%microsoft%';
It works fine.
However when I deploy it to a remote hosted site, and I run the same query, It doesnt work, because it passes the following query:
Select * from patents where casename like \'%microsoft%\';
How do I remove those slasshes?? I even tried trimming the slashes in the string passed to the mysql server but it wont work.