if($checked_feedback =~ m/[']/g) { $checked_feedback =~ tr/'/_/; } $statement = "INSERT INTO Posts(subject,id,heading,body,date,time,approved) VALUES ('$subject','$ids','$post_title','$checked_feedback',CURDATE(),CURTIME(),1)"; $insert = $db->prepare($statement) or die "Couldn't prepare the query:", $rv = $insert->execute or die "Order insert failed: ", $insert->finish();