double escaping quotes in php/sql

[mattc]

Hi all,

I'm writing some php for a mysql driven site and I'm having trouble disabling magic quotes on the server.

I'm keen to write portable code so i'm using mysql_real_escape_string() but of course I'm ending up with double \\ on ' etc on this server

just wondering if anyone can think of an example where this could be a particular problem?

Thanks,

Matt

[meden]

can't you just switch off magic quotes with a .htaccess file? As far as I was aware very few hosts use them now anyway...they're off by default mostly and are not even in PHP6 so may be worth switching hosts anyway