run multiple queries

[eluser]qcsites[/eluser]
You can do something like this.

Code:

function insertalldata(){
  
    $data_mem = array(
      'memberid'=> null,
      'lastname' => $this->input->post('lastname'),
      .
      .
      .
    );
    $this->db->insert('tbl_member',$data_mem);
  
    $data_auth = array(
      'authid'=> null,
      'fkmemberid' => null,
      'username' => $this->input->post('username'),
      .
      .
      .
    );
    $this->db->insert('tbl_auth_member',$data_auth);
  }