我有这个表：tbl_module_bid
图像：
https://i.stack.imgur.com/4hQBN.png
你看到的用户：Ali2，Ali，blackbone，dickpace，mhmd让我们为它们中的每一个调用$player和我想在中使用的sql查询
mysql_query("UPDATE `bbcsystem`.`tbl_admin` SET games_played = games_played + 1 WHERE username = $player");
我尝试使用以下脚本：
//Update Game Played (not working very good):
$num_qry = "Select DISTINCT * From tbl_module_bid where user = '".$_SESSION['LOGIN_BALANCE_FRONT']['name']."' AND module = '$mod_id' order by bid asc";
$get_pick = $db->get_results($num_qry,ARRAY_A);
foreach($get_pick as $arr_pic)
{
$player = $arr_pic['user'];
mysql_query("UPDATE `bbcsystem`.`tbl_admin` SET games_played = games_played + 1 WHERE username = $player");
}
好吧，我想做的是，取tbl_module_bid中的所有用户名，对于表中的每个用户，我将在另一个表中更新他的信息（玩过的游戏），我对stackoverflow和phpp真的很陌生。。请考虑帮我一个忙：）谢谢
试试这样的东西：
UPDATE tbl_admin a
INNER JOIN tbl_module_bid b on a.username = b.user
SET a.games_played = games_played + 1
WHERE b.user = $_SESSION['LOGIN_BALANCE_FRONT']['name']
AND b.module = $mod_id
这在一个查询中完成两个查询。
如果@Filipe做对了，那么这里是一个干净的版本
<?php
$q = 'UPDATE tbl_admin AS a'
.' INNER JOIN tbl_module_bid AS b ON a.username=b.user'
.' SET a.games_played=games_played + 1 WHERE b.module = "'.$mod_id.'"';
$result = mysql_query($q);
不要忘记将他的答案标记为答案