title: Codeigniter model with multiple update conditions using manual where statement
body: <p>I have this code in model that returns data</p>
  
  <pre><code>$this-&gt;db-&gt;select('title, content, date');
  
  $where = "name='Joe' AND status='boss'";
  
  $this-&gt;db-&gt;where($where);
  
  $query = $this-&gt;db-&gt;get('mytable');
  
  return $query-&gt;result();
  </code></pre>
  
  <p>I am using a manual <code>where</code> and i wanted to know whether the concept of manual where in updates and possibly in deletes is allowed.</p>
  
  <p>This code updates a table based on a single <code>where</code> condition</p>
  
  <pre><code>$data = array(
                 'title' =&gt; $title,
                 'name' =&gt; $name,
                 'date' =&gt; $date
               );
  
  $this-&gt;db-&gt;where('id', $id);
  $this-&gt;db-&gt;update('mytable', $data);
  </code></pre>
  
  <p>Is doing this allowed in codeigniter</p>
  
  <pre><code>$data = array(
                 'title' =&gt; $title,
                 'name' =&gt; $name,
                 'date' =&gt; $date
               );
  
  $where = "id=$id, name='Joe' AND status='boss'";
  
  $this-&gt;db-&gt;where($where);
  
  $this-&gt;db-&gt;update('mytable', $data);
  </code></pre>