else if($dopost == "okoperations")
{
$nid = preg_replace('#[^0-9,]#', '', preg_replace('#`#', ',', $nid));
$nid = explode(',', $nid);
$duix = $dsql->GetOne("SELECT mid FROM #@__member_operation WHERE aid = '$var'");//得到要增加的会员mid
$hasMoney = 10;//想给会员增加10个金币
if(is_array($nid))
{
foreach ($nid as $var)
{
$query = "UPDATE `#@__member_operation` SET sta = '2' WHERE aid = '$var'";
$dsql->ExecuteNoneQuery($query);
$dsql->ExecuteNoneQuery("UPDATE #@__member SET money=money+$hasMoney WHERE mid='$duixz'");//增加金币
ShowMsg("设置成功!","member_operations.php");
exit();
}
}
}
测试如果把代码换为数字,是可以成功的。
$dsql->ExecuteNoneQuery("UPDATE #@__member SET money=money+10 WHERE mid='7'");//增加金币
如果这样是可以达到效果的,意思是给ID为7的会员,增加10个金币。
UPDATE #@__member SET money=money+{$hasMoney} WHERE mid='$duixz'
已补充,麻烦给看一下,多谢。