Mysql query
#1

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_]);
Reply


Messages In This Thread
Mysql query - by IgrexolonO - 27.01.2013, 08:25

Forum Jump:


Users browsing this thread: 3 Guest(s)