Use of ' in a insert..??

[Anon]

When inserting to e text field in my mysql db... i get error if I use

cloney's .... I have to write cloney\'s.. but...the problem is, if someone writes an article for me.. and they don't know that they "need" to use \ before '... how do I solve this..?

[Anon]

use this:

$name = "cloney's";
$name = addslashes($name); /- name becomes cloney\'s -/
mysql_query ("INSERT INTO .... ");

if you wanna read it out again:

mysql_query ("SELECT .... ");
$name = stripslashes($name);
echo $name; /- outputs cloney's -/

thats about it...

[Anon]

Better yet use this function for your output.

stripslashes($field);

That way you dont have to worry about what gets inputed. Slashes will all be removed with this on your output

PHP4