replacing single quotes?

[Nanoblaze]

any way to do this? by single quote i mean ' ... ive tried ereg and preg replace to no avail, and am rather baffled as to why its not working... its being inserted into a mysql database, also, since that makes a slight difference in how its handled...no errors are reported on insertion, so i ask you all. 🙂

[mahers]

Do you mean that you are removing the ' before inserting into the database? I'm sorry I don't really understand the question.

[Nanoblaze]

im wanting to replace the ' with \' so it isnt processed as the end of that part of the query.

[Nanoblaze]

to elaborate... i type it's and it doesnt work...
i replace it's ' with \' using ereg_replace ( which does work ) and it doesnt work when inserting.

I replace ' with \' manually ( type it\'s instead of it's ) and it DOES insert and works... when outputting the data after its entered, the automatic replacement ( ereg_replace ) and manual replacement ( me typing it in with the \ ), they look exactly alike...no differences that i can see...

[mahers]

Ok I understand now. I think your after the addslashes() and stripslashes() functions. e.g

$text = "Test's";

$text = addslashes($text);

$text should now contain Test\'s

Then to turn the \' into ' again use the stripslashes() function the same way. Hope this helps.

[Nanoblaze]

i think i love you 😃

now that i didnt know that is deplorable. thank you for educating me =)

[mahers]

Glad to help 🙂