Small question about MySQL - 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: Small question about MySQL (/showthread.php?tid=598973)
+- 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: Small question about MySQL (/showthread.php?tid=598973)
Small question about MySQL - Squirrel - 19.01.2016
Since you cannot use '%e' in format or insert, how the heck do I then escape string? Im talking about tQuerries.
For example how would I escape string here with tQuerries
PHP код:
UPDATE `players` SET `Username`='%s' WHERE `ID`=%d
Re: Small question about MySQL - Gammix - 19.01.2016
MySQL has its own specifier "%e" which can be used in MySQL's format.
SAMP introduced its own in 0.3.7 which is "%q" and can only be used in "format".
Re: Small question about MySQL - Squirrel - 19.01.2016
Well I tried using %e earlier but I was told by Jeff I cannot use it inside formats
Re: Small question about MySQL - SickAttack - 19.01.2016
You use "%e" on "mysql_format", and "%q" on "format".
Re: Small question about MySQL - Squirrel - 20.01.2016
Quote:
|
Originally Posted by SickAttack
 You use "%e" on "mysql_format", and "%q" on "format".
|