saving mysql - Printable Version

saving 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: saving mysql (/showthread.php?tid=571279)

saving mysql - iBots - 17.04.2015

i have made a system,but the problem is that if i want to detect the right row to update,i should use 2 %d at WHERE,like

pawn Код:

UPDATE 'filename' SET `thing`=%d WHERE `item1`=%d, `item2`=%d

but it doesnt work like this,how to make it work
NOTE:for these people who say "detect it using only 1 %d,i cant,because they can have same item 1 and different item 2 or different item1 and same item 2

Re: saving mysql - Misiur - 17.04.2015

Код:

UPDATE `filename` SET `thing`= %d WHERE `item1`= %d AND `item2`= %d

Like this.

Re: saving mysql - iBots - 17.04.2015

thanks