query help!

[Anon]

I know of 2 methods to handle the single quotes in a SQL query while inserting data (ie: INSERT query). One is to replace each single quote with two single quotes and the other is to use the addslashes function to negate the single quote.

My question is, if there is a robust way (or function) to handle single quotes in a SQL query?

Please help!

[Anon]

BTW, I seem to be having problems with both the methods. The replace method causes errors with single & double quotes and the addslash function adds a slash to the string being stored in the database.