MySQL is auto escaping all commands

[Marion Fauber]

I just changed my web hosting site. I uploaded several web pages that use PHP & MySQL. Almost everything worked right off the bat. I did find that any SQL cmd I submitted that contained a quoted string did not come back with results. I then used phpMyadmin with the following cmd:

SELECT * FROM table WHERE name='anyname';

The cmd failed with a syntax error. Looking further I found that all of the single quotes were automatically escaped ( I tried using double quotes with the same result). MySQL actually escaped ( with \ ) the quotes and also escaped the \ several times. Thus resulting in a syntax error.

I have used MySQL on my personal development computer and also on other web hosting sites and have never seen MySQL behave this way...

Any thoughts on what I can do to eliminate this "Feature".