[Resolved] Filtering reserved characters.

[Reapz]

Certain parts of my webby involve users and admins adding or editing data in a MySQL databse. I know from experience that there are certain reserved characters that you can't use in the entered data because the database won't update. One of which is the apostrophe ( ' ).

What I would like to know is what other characters need filtering out of form data before updating the database and the PHP code to do it.

Thanks!

Andy!

[Reapz]

Better still would be a way to keep the apostrophes etc... but I don't know whether that can be done.

[xblue]

take a look at
http://www.php.net/manual/en/function.addslashes.php
or
http://www.php.net/manual/en/function.mysql-escape-string.php