in reply to text entry into mysql using perl

An real easy way to fix this problem is to simply alter your var

Example:

$body =~ s/([\'\`])/$1$1/gi;

This covers both forms of apostrope, doubleing it which is insert friendly ( only one gets inserted )

Since im one of those people who like to reinvent the wheel ( or better put carry my blueprints around ) for form_parsing, i just make the conversion automagically while my forminput is being stuffed into my arrays.

$value =~ /([\`\'])/$1$1/gi;

Pete