Revising Function

[eluser]apodner[/eluser]
You can just basically roll the first insert back if the 2nd one fails.

Code:

public function save_title($title_name, $title_directory_name, $title_status_id)
{
    $data = array(
     'title_name' => $title_name,
     'title_directory_name' => $title_directory_name,
     'title_status_id' => $title_status_id
    );

    $this->db->insert('titles', $data);  
    if ($this->db->affected_rows() == 1)
    {
        $insert_id = $this->db->insert_id();
        $data = array(
        'title_id' => $insert_id
        );

        $this->db->insert('title_champions', $data);

        if ($this->db->affected_rows() == 1)
        {
            return true;
        }
        else
        {
            $this->db->where('title_id', $insert_id);
            $this->db->delete('titles');
            return false;
        }
    }
    else {
        
        return false;
    }
}