escape apostrophe in text field

[earle]

How do you escape an apostrophe in a text string?<br>
<br>
For example, using:<br>
String = &quot;Can't escape apostophe&quot;.<br>
<br>
When update/inserting a record with the above string in the field being updated, it errors.<br>
<br>
I've tried replacing the one apostrophe with 2 apostrophes ala Oracle. and I've tried using the MySQL escape character &quot;\&quot; such that &quot; ' &quot; was replaced with &quot; \' &quot;. Neither escape sequence worked. <br>
<br>
What now?<br>
Ed

 

[robman]

What language are you using?

 

[earle]

Sorry, I'm using PHP. But the problem was solved when I truned on the enable-magic-quotes function in PHP.<br>
<br>
Thanks<br>
Ed

 

[Karl Blessing]

how would you solve it without enable-magic-quotes? Karl Blessing aka kb244{fastHACK}