how to handle single quatation strings from client when inserting into table?

[scorpioy]

I have a form in the webpage. If I have some single quatation in the input, I will have some mysql error when inserting it into the table. How should I handle this?

Thanks.

[planetsim]

Any data coming from POST, GET, COOKIE etc. should use the addslashes(); and other checking. As this is coming from the user the data shouldnt be trusted.

When displaying the data again use stripslashes(); however i believe there is a MySQL Function that does this which will make the script slightly faster.