Mysql query - 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 query (/showthread.php?tid=410910)

---

Mysql query - IgrexolonO - 27.01.2013

Hello!! I want to get values, from 2 tables in database. First table is players, and 2nd is mybb_users. The first one I can take easily, but I want to take mybb_users value using players value (forumID). So I want add to this query \/ taking `username` FROM `mybb_users` WHERE `uid`='forumID'. Help me please!!

format(sqlquery, 256, "SELECT `gid`, `forumID`, `adminLvl`, `skin`, `money`, `bMoney`, `lastPosX`, `lastPosY`, `lastPosZ`, `lastPosAngle` FROM `players` WHERE `login`='%s'", playerInfo[pid][playerName_]);

---