mysql escape characters

[XandroZ]

I need to insert a text into a Mysql table.The text contains ',";
So I tried mysql_escape_string or mysql_real_escape_string functions.

The problems is with this type of string,for example:

Nancy's dog

and after I applied the function

Nancy\'s dog

(escaped), but mysql doesn't recognize the escaped character.

I have :
# MySQL 5.1.33
# PHP 5.2.9

[SJH]

Can you post the exact query and the error?

[risoknop]

Seems like you are applying addslashes() to the string before you insert it in the database but that's just my guess.

We need to see the code or else we probably can't help you.