Problem with inserting quote marks

[coppercoins]

I'm writing an application where customers are inserting comments into the database. My problem is that when they use the double quote marks it truncates the comment to the first quote mark. If I replace the quotes with &qout; before inserting, the insert doesn't occur at all. What's going on here?

[ultraslacker]

Have you tried php function addslashes?

[coppercoins]

I don't think that will do any good since the DB doesn't care whether or not the quotes are commeted - it still truncates the entry. What I did to alleviate the problem was this:

upon entry into the DB, I read the string for quotes, then placed an eregi_replace('"', 'QQQ', $string) function before the DB insert, the upon pulling the string from the DB I ran the opposite, eregi_replace('QQQ','"',$string). That stores QQQ in the DB for a quote, but shows " on screen. Works, but isn't highly clean.

[TheIceman5]

as ultraslacker said above, have you tried the function addslashes?? It WILL work. it truncates it because it thinks its the end of the string, you have to tell it otherwise, addslashes does that.