i'm just in the testing phases of my user profile system. I have the following problem:
All of the user profile info is stored in a mysql database, all works ok, except when a user puts in a " into a field, it submits OK, but when displaying it on the user profile page, it displays everything before the ", but nothing after.
Take this for example:
I am 19 years old, i am 5"11, blonde hair, blue eyes. I like to program with PHP.
This displays as:
I am 19 years old, i am 5
This is obviously corrupting the HTML. How can i get the " to show up as a ", rather than corrupting the HTML?