Apostrophe's

Hello... Using PHP and MYSQL in various database projects, I have run into the problem of having an apostrophe -- ' -- in a value.. For example, if someone submits "Bob's Wharehouse" as a value for the column SUPPLIER, I have to go in and either remove the apostrophe or "double" it ('') so it is interpreted appropriately. I have been doing this with the following code: $NAME = strtr($NAME, "'", "''"); I am wondering if there is an easier way to take care of this problem. As I am working with bigger database projects, it's becoming a real hassle to have to do this for every variable. Maybe there is something different I can do in my query string writing? Any suggestions will be much appreciated. Thanks, Dustin Leggans dustinl@rocketmail.com __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com