Mysql and comma s ('s) problem

[Anon]

Hello all,
A strange error in my database. I have set up a database with 4 tables on a win32 server. It contains one table witch stores data so I set that one to TEXT. As soon as I update this field with something like member's it freaks out and does not display the 's. I tried to do this on my linux server and all is well. I use the latest php, mysql, apache, perl and so on. Help I am stuck.

ROn

[mithril]

Your query strings aren't getting escaped properly before you pass them off to MySQL. It sounds like you may have magic_quotes enabled on the linux box, but not on win32. I'd suggest going through the php.ini's and making sure that all the x-platform settings match up.

Also, it's a good practise to always call addslashes() on text fields (TEXT, CHAR, VARCHAR, etc.) when creating the insert/update query and then stripslashes() on the returned data from a select query. Do that and you won't go wrong, your code will also be more portable since you will eliminate problems like this one.

-geoff

[Anon]

Thank you very much.. It did the trick :-)
Ron

[Anon]

A really good one is mysql_escape_string()