mysql escaped strings - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql escaped strings (/showthread.php?tid=282034)

---

mysql escaped strings - scottyishere - 09.09.2011

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.

---

Re: mysql escaped strings - FireCat - 09.09.2011

Show us the errors.

---

Re: mysql escaped strings - scottyishere - 09.09.2011

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.

---

Re: mysql escaped strings - scottyishere - 10.09.2011

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

---