title: Can I determine the key of the query_result array in Codeigniter?
body: <p>in <code>get_poll</code> function in following <code>Poll</code> model:</p>
  
  <pre><code>class Poll_model extends CI_Model 
  {
      public function get_poll($parameter) {
          $this-&gt;db-&gt;select('question.id, question.title, question.question, answer.answer')-&gt;from('answer')-&gt;join('question', 'answer.question_id = question_id')-&gt;where('question.id',$parameter);
          $query = $this-&gt;db-&gt;get();
          return $query-&gt;result_array();
  }
  </code></pre>
  
  <p>Because I'm using join to get result from 2 table and  table <code>question</code> and <code>answer</code> both have column <code>content</code>, so in the result_array, the structure like this:</p>
  
  <pre><code>Array ( [id] =&gt; 1 [title] =&gt; favourate character [content] =&gt; Green ) 1
  </code></pre>
  
  <p>The there's only <code>answer content</code>, I think the <code>question content</code> was overwrite, because both of them have the same column 'content'. the table structure shown below:</p>
  
  <pre><code>CREATE TABLE `answer` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `question_id` int(11) unsigned NOT NULL,
    `content` text NOT NULL,
    PRIMARY KEY (`id`),
    KEY `question_id` (`question_id`),
    CONSTRAINT `answer_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `question` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(128) NOT NULL DEFAULT '',
    `content` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>Is there any way to solve this problem?</p>