[scottyishere]

Hai!

I have a small problem. I am escaping strings into the database (e.g. scott's -> scott\'s) but after a while (UPDATE queries) the string seems to revert to scott's and then it starts giving mysql errors. What might be the problem? Why does it revert to scott's?


Thanks.

[FireCat]

Show us the errors.

[scottyishere]

the error ID is 1064 and it's because the " ' " fucks up the query. something goes wrong after a while because it reverts to ' instead of \'. The string gets escaped at first.

[scottyishere]

24 hours have passed, I think I can bump the post now.