I found out that ther are problems with a string like this:
"O'Relly is my name"
Before you add this to the mysql database you need to add a \ for the ' charter.
Example:
sub AddSlashes {
$text = shift;
## Make sure to do the backslash first!
$text =~ s/\\/\\\\/g;
$text =~ s/'/\\'/g;
$text =~ s/"/\\"/g;
$text =~ s/\\0/\\\\0/g;
return $text;
}
$str = "O'Relly is my name";
print AddSlashes($str);
Output: O\'Relly is my name
oke, i have a fix for it so i can send you the code if you want. What is your mail adres?