title: codeigniter use set() with insert_string()
body: <p>Using CI, I need to do an insert ignore with a subquery. I get a code igniter error when I try to do this:</p>
  
  <pre><code>$data = array(
              "user_id" =&gt; $user_id,
              "workload_id" =&gt; $wid
      );
      $this-&gt;db-&gt;set($data);
      $this-&gt;db-&gt;set("order", "(SELECT ifnull(max(`order`)+1, 0) FROM (SELECT * FROM default_workloads_users A ) B WHERE user_id=".$user_id.")", FALSE);
      //$this-&gt;db-&gt;insert("default_workloads_users");
      $ins = $this-&gt;db-&gt;insert_string("default_workloads_users");
      $ins = str_replace("INSERT", "INSERT IGNORE", $ins);
      $this-&gt;db-&gt;query($ins);
  </code></pre>
  
  <p>It tells me I am missing the second parameter to insert_string. Thoughts?</p>