I was having a hell of a time with single quotes in a SQL insert. I was using addslashes() etc but it would not work 100% of the time. So I just suround the text I want to insert in double quotes.

$sql=”INSERT INTO TABLE SET FIELD=\”It’s good to be quoted\” ”;

Then when I get data back I just run stripslashes()