我有这个INSERT:
INSERT INTO gamecodes (gamecode, accountname, premium_points, alreadyused)
VALUES ('$gamecode','$accountorname',$premiumpoints,'N')
我需要帮助。在变量$accountorname我得到了一个球员的名字,我需要得到他的帐户。
两个表:
TABLE PLAYERS
id, name, account_id..
id, player name, table accounts.id
TABLE ACCOUNTS
id, name ..
id = table players account_id
您可以尝试这样做:
INSERT INTO gamecodes (gamecode, accountname, premium_points, alreadyused)
SELECT '$gamecode',accounts.name,$premiumpoints,'N'
FROM accounts
JOIN players
ON accounts.id = players.account_id
WHERE players.name = '$accountorname'
您的查询可能看起来像-
INSERT INTO gamecodes( gamecode, accountname, premium_points, alreadyused)
VALUES('$gamecode', '$accountname', $premiumpoints, 'N')
WHERE(SELECT accountname FROM accounts JOIN gamecodes ON accounts.accountname = gamecodes.accountname WHERE accounts.accountname = $accountname)