Mysql add into table, and apostrophes

admin

Administrator
Staff member
I have an admin program that allows someone to make entries of product listings into a db. I got everything working, yet when someone tries to add in text that has an apostrophe (') in it, the script comes back with an error saying it cannot add it to the db. If you type \' instead, everything goes fine. The person who will be using should not have to type in a \ everytime they use an apostrophe, is there a way around this?
 
Top