apostrof in query string

[Anon]

Hi!

I'm developing PHP on two linux servers, and on Windows. I have queries like: "insert into table values ( '$string' )" $string is coming from submitted form. If this submitted string contains apostrof ('), than on one of linuxes and on windows it is working OK, but on another linux the query fails. I'm using apache as webserver on all three computers, and mysql as dbserver. Can anybody tell why it is not working on one of the linux servers?

Thx a lot.

Bruce

[Anon]

You don't have magic_quotes_gpc turned on in php.ini?

[[deleted]]

Because you are not using the addslashes() function, or your magicquotes is f-ing things up.

The apostrphes in your query must be escaped by a backslash.
IN some PHP setups this happens automatically, in some setups this has to be done manually.
Personally I prefer to do it manually, because the automatic systems often f-up.