Question

请问一下代码如何修改能影响多行数据，谢谢

$goods_num = pdo_fetchcolumn('SELECT goods_num FROM ' . tablename('wc_order_stat') . " WHERE uniacid = :aid AND oid = :oid", array(':aid' => $_W['uniacid'], ':oid' => $id));
$goods_id = pdo_fetchcolumn('SELECT goods_id FROM ' . tablename('wc_order_stat') . " WHERE uniacid = :aid AND oid = :oid", array(':aid' => $_W['uniacid'], ':oid' => $id));
$total = pdo_fetchcolumn('SELECT total FROM ' . tablename('wc_goods') . " WHERE uniacid = :aid AND id = :id", array(':aid' => $_W['uniacid'], ':id' => $goods_id));
$goods_bnum = $total + $goods_num;
if ($total > -1){
pdo_update('wc_goods', array('total' => $goods_bnum), array('uniacid' => $_W['uniacid'], 'id' => $goods_id));
}

Answer 1

影不影响多天跟where条件有关，如果本来筛选出来就一天，怎么可能影响多天呢？。
你应该按照你的业务逻辑调整sql条件

Answer 2

你可以试试去掉where后面到行末的内容。

追问

是影响指定的行，行数有多条，我这样写只能影响一行，能不能改一下，写成影响多条指定的行数据

追答

pdo_fetchcolumn的问题，换个函数。