这是我的表
----------
id | user_id | sid | fid | channel
----------
1 | 10usl1 | 1029298 | null | snapdeal
我有更新fid和通道flipkart,然后通道字段删除snapdeal,但我想要snapdeal,flipkart
update query do not remove snapdeal for channel field请帮帮我
我的代码
public function set_response_data($id,$data){
$whereCondtions = array(
'user_id' =>$this->user_id,
'id' => $id);
$this->db->where($whereCondtions);
$this->db->update($this->table, $data);
return $id;}
Sql query
UPDATE tbl_name SET `channel` = CONCAT($data['val'], ' , ',channel), `fid` = $data['fid'] WHERE $whereCondtions;
IN codeigniter您只需以concat形式发送通道值…
Like $data['val'] = CONCAT('snapdeal', ' , ',channel)