" in mySql update via PHP

admin

Administrator
Staff member
Hi!

I've a problem updating mysql database through php.

If new value contains inverted commas("), none of my "solutions" works..

i've tryed many ways, last one was replacing " with \" like this:

str_replace('"','\"',$rec[0]) before executing command...

but after executing mysql_query everything after " gets lost :(

I used update syntax(update table set...) The value are collected from form elements...

Q: How can I update database so that inverted commas wouldn't "get lost".

Thanks:)
 
Top