Update a mysql database and retain special characters
To update a mysql database and retain special characters such as possessiveness, or if you are updating a database where you field contains any special characters you will need to use the “addslashes” function to your mysql statement.
View Code PHP
$updateSQL = sprintf("UPDATE db_table SET db_field=%s WHERE db_row='".addslashes($title)."'", GetSQLValueString($value, "text")); |




