not changing ' in mysql query's

[Anon]

I have just started working on a new server with php 4.2.1 and when i run a mysql query where the variables have "'" it barf's. I have never had this problem before is there something i need to change in the php.ini file?

Thanks for any suggestions

[sp0rk]

Use mysql_escape_string($variable) and you're safe.

[Anon]

Check in php.ini and fiddle with
magic_quotes_runtime
and
magic_quotes_sybase

This may be simpler than rewriting all your database-accessing scripts.