note 20431 added to function.addslashes

addslashes does not work in Access for inserting fields that contain single quotes or apostrophes. For Example: $fieldOne = "Eat At Joe's"; $fieldTwo = "Delectable Dining at Fabulous Fares"; $query = "INSERT INTO Table (fieldOne,fieldTwo) VALUES ('$fieldOne','$fieldTwo')"; Returns a syntax error. This can be fixed by using a regular expression to replace the single quote with the ` character (on a QWERTY keyboard -- above the TAB). You can always replace it back when outputting the information, but it still looks similar and will be recognizable to users who are not familiar with your replacement reasoning. Example (place before the $query statement): $fieldOne = ereg_replace("\'","`",$fieldOne); -- http://www.php.net/manual/en/function.addslashes.php http://master.php.net/manage/user-notes.php?action=edit+20431 http://master.php.net/manage/user-notes.php?action=delete+20431 http://master.php.net/manage/user-notes.php?action=reject+20431