[RESOLVED] Server escaping string in a weird way for database query

[Alex-Grim]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's set up and you\''ve rebooted, log into your desktop and look for the network i' at line 1

The part where it says "you\''ve" is what concerns me. In my code, i tell it to replace a single quote with two single quotes. I don't know where the hell the backlash is coming from, but i'm guessing that php is doing it automatically. How can i stop this, so that it doesn't convert my words into weird characters (see the characters in the article i just posted at the link below to see what i'm talking about). Because that backlash is in there, and because i'm replacing single quotes, php is interpreting the slash as whitespace type stuff, and generating wired characters.

http://linuxintro.com/?con=Fstab01

Thanx

[Alex-Grim]

Stripslashes();, then do the two single quotes 😉

[NogDog]

The back-slash is probably coming from having the dreaded magic_quotes_gpc PHP configuration option turned on. You can use the [man]get_magic_quotes_gpc/man function to check for this in order to decide if stripslashes is needed (or just disable magic_quotes_gpc if you can).

[Alex-Grim]

Thanx, i don't know if t is set for my webhost, i'm sure that i can check later, but i went ahead and used the backslash to fix the problem. EX:
$contents =ereg_replace("'","''",( stripslashes ( $_POST['contents'])));