Replacing &#39 in database with '

[hallm]

I've got a database that I'm converting over to php / mysql. Alot of the text entries have &#39 instead of ' saved in. For example don&#39t instead of don't. I've tried running str_replace on it and it's not working. Am I missing something?

hallm

http://www.fatgenie.com

 

[sleipnir214]

When you say, "I've got a database", exactly what format is the file?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[hallm]

I should say that the database is already in Mysql. We converted it from Access. html_entity_decode seems to be working, I'm going to play with it for a while. Thanks for your help.

hallm

http://www.fatgenie.com