Saving quoted text to DB
Posted on 2002-05-02
I'm wondering how you do this. I have a text area which people can write a comment in. The problem is, if they write:
Today's a lovely day, isn't it
I get an error when I update the database because of the quotes (appostrophes) embedded in the text.
How do I let the text get saved without losing the quotes?
Also, if someone types:
How's it going?
How do I get the carriage returns to be replaced with breaks? And, how can I convert the spaces to ?
I'm sure there is a really simple way of doing all this, I just can't find it :)
Thanks for your help,