在codeigniter中使用多个where条件更新表

Question

I have to update the table if only the three values gets matched. I get a syntax error on trying this. What could be the reason?

 $sql1="update target set updvalue='".$val3."'  where Id ='".$b."'" AND MId ='".$c."'" AND DID ='".$f."'";
 $res1=$this->db->query($sql1);

Answer 1

$sql1="update target set updvalue='".$val3."'  where Id ='".$b."' AND MId ='".$c."' AND DID ='".$f."'";
$res1=$this->db->query($sql1);

use this