用户
 找回密码
 入住 CI 中国社区
搜索
查看: 1121|回复: 1
收起左侧

[版本 3.x] 批量更新的问题 求解

[复制链接]
发表于 2016-12-13 11:48:15 | 显示全部楼层 |阅读模式



data数组是
array(2) { [0]=> array(2) { ["id"]=> string(2) "10" ["kejian"]=> int(1) } [1]=> array(2) { ["id"]=> string(2) "11" ["kejian"]=> int(1) } }




$this->db->update_batch('pinglun',$data,'id');


报了两个错误

错误一

Severity: Notice

Message: Undefined index: id




错误二

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN '10' WHEN `id` = THEN '11' ELSE `id` END, `kejian` = CASE WHEN `id` = TH' at line 2

UPDATE `pinglun` SET `id` = CASE WHEN `id` = THEN '10' WHEN `id` = THEN '11' ELSE `id` END, `kejian` = CASE WHEN `id` = THEN 1 WHEN `id` = THEN 1 ELSE `kejian` END WHERE `shangjia_id` = '1' AND `id` IN(,)


发表于 2016-12-13 15:23:38 | 显示全部楼层
代码贴全一些看看,看起来是 SQL 语句的问题。

本版积分规则