批量更新的问题 求解
data数组是
array(2) { => array(2) { ["id"]=> string(2) "10" ["kejian"]=> int(1) } => array(2) { ["id"]=> string(2) "11" ["kejian"]=> int(1) } }
$this->db->update_batch('pinglun',$data,'id');
报了两个错误
错误一
Severity: NoticeMessage: Undefined index: id
错误二
Error Number: 1064You 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 2UPDATE `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(,)
代码贴全一些看看，看起来是 SQL 语句的问题。
页:
[1]