quotes

Hey, I have a problem using apostrophes/single quotes. I am using PHP and MySQL. The user enters data into the text field and everything goes ok, until an apostrophy/single quote is added in the middle of the text - then disaster occurs! Now i want to allow the user the ability of adding apostrophies/single quotes. As far as i understand the reason is because MySQL accepts the text until the apostropy/single quote. So my guess would be if that i should manipulate the text before inserting into the database, such that it doesn' include apostrophies/single quotes. But is there something else i could place instead of the apostrophy/single quote that would, when displayed, show as an apostropy/single quote. Any ideas? Help would be great! Heidi ===== Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/