SA-MP Forums Archive
MySQL WHERE Question. - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL WHERE Question. (/showthread.php?tid=153138)


MySQL WHERE Question. - oliverrud - 07.06.2010

So I'm currently building something for a HQ on my server, I'm however wondering if it's possible to like have two %s after a WHERE like:

Код:
WHERE FactionPass = '%s' ID = '2'
Код:
WHERE FactionPass = '%s', ID = '2'
This is the two ones I tried but none succeed, heres the whole actual string

pawn Код:
format(stringsize, sizeof(stringsize), "SELECT * FROM "SQL_FACTION" WHERE FactionPass = '%s' ID = '2' LIMIT 1",inputtext);


Re: MySQL WHERE Question. - Aleksandar_Zivanovci - 07.06.2010

pawn Код:
format(stringsize, sizeof(stringsize), "SELECT * FROM "SQL_FACTION" WHERE FactionPass = '%s' ID = '2' AND something = '%s'",inputtext, something);


Re: MySQL WHERE Question. - oliverrud - 07.06.2010

Quote:
Originally Posted by Aleksandar_Zivanovci
pawn Код:
format(stringsize, sizeof(stringsize), "SELECT * FROM "SQL_FACTION" WHERE FactionPass = '%s' ID = '2' AND something = '%s'",inputtext, something);
Thanks man!

Re: MySQL WHERE Question. - Aleksandar_Zivanovci - 07.06.2010

np