Hi Guy's I have an issue when posting text that has a single quote " ' ". The data just won't load.
//get template & load data
$tpl = file_get_contents('tpl/update_form.html');
echo str_replace(array_keys($tpl_vars),array_values($tpl_vars),$tpl);
} elseif(isset($_POST['update'])){
$notes = mssql_escape($_POST['notes']);
$notes2 = mssql_escape($_POST['notes2']);
$notes3 = mssql_escape($_POST['notes3']);
$notes = $_POST['notes'];
$notes2 = $_POST['notes2'];
$notes3 = $_POST['notes3'];
$tpl_vars = array();
$tpl_vars['{{title}}'] = "Session Notes Update Complete";
$sql1 = "UPDATE session_notes
SET notes = '$notes',
notes2 = '$notes2',
notes3 = '$notes3'
WHERE appointment_id = '$appointment_id'";
If any text contains an ' Single quote it won't updat the data in the table.