mysqli real_escape_string problem

When im inserting to the database on my dev server the text goes in fine, for exampl开发者_开发技巧e "that's" is "that's" in the db.

when uploading the exact same code to production server (hosted on a reseller account at bluehost) "that's" becomes "that\'s",

im not double escaping, its exactly the same code, what could be the issue here?

The production server probably has Magic Quotes enabled. See the page about disabling it for various options to fix it.