Mysql add into table, and apostrophes

[viveleroi0]

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?

[viveleroi0]

$addprodlist="INSERT INTO Products (ProdCat, SubCat, ID, ProdName, ProdPrice, ProdDesc, ProdImage, ProdDate, ProdMisc) VALUES ('$ProdCat', '$SubCat', '$ID', '$ProdName', '$ProdPrice', '$ProdDesc', '$ImgSrc', '$DateAdded', '$ProdMisc')";

when the form has an ' in it anywhere, the php code/mysql prouces a parse error. If you type in a \' then its fine.