我的数据库中有一个名为member的表,该表中的字段是'personID&balance`‘。
如果用户1的余额为20.00,并且希望将10.00发送给用户2,那么减少用户1的余额和更新用户2的余额的最佳方法是什么?
任何帮助/建议都会很好!
提前感谢
更新
代码:
$accountfrom=$_POST[accountfrom];
$accountto=$_POST[accountto];
$amount=$_POST[amount];
$con = mysql_connect("localhost","cl49-XXX","XXX");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("cl49-XXX", $con)or die( "Unable to select database");
$result = mysql_query("UPDATE member
SET balance = IF(personID = $acountfrom, balance-$amount, balance+$amount)
WHERE personID IN ($accountfrom, $accountto)")
or die(mysql_error());结果:
“您的SQL语法有错误;请检查与您的MySQL服务器版本对应的手册,以便在第2行使用接近”balance-100.00,balance+100.00)的正确语法,其中personID in (84587745,98554130)“
发布于 2013-11-08 23:18:24
UPDATE member
SET balance = IF(personID = 1, balance-10, balance+10)
WHERE personID IN (1, 2)若要将传输限制在发送方的余额上:
UPDATE member m1
CROSS JOIN (SELECT LEAST(10, balance) transfer
FROM member
WHERE personID = 1) m2
SET m1.balance = IF(personID = 1, balance - transfer, balance + transfer)
WHERE personID in (1, 2)https://stackoverflow.com/questions/19870224
复制相似问题