Apostrophe in database field

[dyedblue]

Whenever I call a field out of my database that contains an apostrophe it puts a "\" before the apostrophe. How can I prevent this from happening?

example:
print("$name"); it will output "David\'s Drycleaning" rather than "David's Drycleaning"

Thanks in advance for your help

 

[Vragabond]

The stripslashes() function should be able to help you. Nice examples are in the manual.

 

[dyedblue]

Worked great! Thanks

 

[kenrbnsn]

Or, when you store the record, store the urlencoded record. When you print, use urldecode.

Ken

 

[dpk136]

This feature is called "magic quotes" it will automatically add the slash to anything that won't go into the db. If you are working on another server where they don't have magic quotes enabled, use the addslashes() function before inserting it into the db. then stripslashes() when it comes out. this will ensure that the data is of good quality.

David

David Kuhn
------------------

http://www.davidpkuhn.com