- Wed May 03, 2017 3:49 am
#790599
I have a addresses and name data fields that contains special character e.g. O'Brien. I tried the following function which does not work.
I am quite sure that if I keep googling I will find a solution but I wonder if there is a 'proper' and 'easier' way to do it with PM?
$db = "<db string>";
$customerName = mysql_real_escape_string(@$customerName);
$sql = "insert into customer (customer_name) values ('$customerName')";
$result = executeQuery($sql, $db) or die ("Error");
I am quite sure that if I keep googling I will find a solution but I wonder if there is a 'proper' and 'easier' way to do it with PM?
$db = "<db string>";
$customerName = mysql_real_escape_string(@$customerName);
$sql = "insert into customer (customer_name) values ('$customerName')";
$result = executeQuery($sql, $db) or die ("Error");