Serious PHP Issue

[alex_samanta]

Hello:

I am encountering a problem with PHP Version 4.1.2. I have written a script that has a form where news can be posted into a MySQL database. Everything works fine except for when the news item contains a ' in it. It won't post then. Any help would really be appreciated.

[Anon]

You need to escape out the string before inserting it into the MySQL database other wise you will get errors.

Simply running add a line that does....

$string_variable = AddSlashes($string_variable);

Before you insert it into the database should help you out.

[spirator]

Matt's is the best way to do it, or you could add your own backslash escape characters, so escape each ' like this: \', but only if you have manual control of the data, of course.

easy
Christo