OK I will do my best to explain this problem that I believe mysql_real_escape_string should resolve but it's not.
Now, at this particular website if I post content with single quotes like "they're" it goes to the data base nicely because of the help of the mysql_real_escape_string php function.
If I look in the database the content is there, nicely...with the strings that contain the single quotes.
BUT! when I try to retrieve the data an error is thrown and the data does not show up on the page it usually would and will if the content does not contain a single quote.
Before showing you the code I"m dealing with, is there something simple that the php/database experts can help me fix in seconds? Does the database settings have to be revised?
I hope this isn't one of those problems that's going to kill me figuring out!
Every bit of help is appreciated.