title: CodeIgniter check if query succeeded
body: <p>I searched online and most of them suggest to use <code>num_rows</code> or similar functions to check if the query has been successful in CodeIgniter, however I am using an <code>update</code> function</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); 
  
  // Produces:
  // UPDATE mytable 
  // SET title = '{$title}', name = '{$name}', date = '{$date}'
  // WHERE id = $id
  </code></pre>
  
  <p>How would I check if this query was successful.</p>