title: codeigniter 2.0 inserting records in two tables at once
body: <p>I'm not sure how to handle this with active records or using manual sql. What I want to do is to add a record into the 'contact' table which has an auto incremented id, and then add a record into the "order" table with the id of the corresponding 'contact' record id.</p>
  
  <p>I know I can get the id of the inserted contact record using $this->db->insert_id(), but does that only work when using active records? </p>
  
  <p>Also, can I achieve this type of insert in one query, or must I split it up in two?</p>