RIGHT OUTER JOIN не возвращает данные из обеих таблиц в CodeIgniter [дубликат] ⇐ Php

[Anonymous]

Я использую запрос JOIN в CodeIgniter и не могу заставить его работать. Он отображает только данные одной таблицы, но не отображает данные другой.
просмотреть












контроллер
function getall() {
$this->load->model('result_model');
$data['query'] = $this->result_model->result_getall();
// print_r($data['query']);
// die();
$this->load->view('result_view', $data);
}

модель
function result_getall()
{
$this->db->select('tblanswers.*,credentials.*');
$this->db->from('tblanswers');
$this->db->join('credentials', 'tblanswers.answerid = credentials.cid', 'right outer');
$query = $this->db->get();
return $query->result();
}

РЕДАКТИРОВАТЬ
Результат
print_r($data['query']);
die();

представляет собой массив, как показано ниже:
Array (
[0] => stdClass Object (
[answerid] =>
[userid] =>
[questionid] =>
[answerA] =>
[answerB] =>
[answerC] =>
[comment] =>
[cid] => 83
[name] => Edvinas
[second_name] => liutvaits
[phone] =>
[email] => ledvinas@yahoo.ie
)
[1] => stdClass Object (
[answerid] =>
[userid] =>
[questionid] =>
[answerA] =>
[answerB] =>
[answerC] =>
[comment] =>
[cid] => 84
[name] => Edvinas
[second_name] => liutvaits
[phone] =>
[email] => ledvinas@yahoo.ie
)
[2] => stdClass Object (
[answerid] =>
[userid] =>
[questionid] =>
[answerA] =>
[answerB] =>
[answerC] =>
[comment] =>
[cid] => 85
[name] => Edvinas
[second_name] => Liutvaitis
[phone] =>
[email] => ledvinas@yahoo.ie
)
[3] => stdClass Object (
[answerid] =>
[userid] =>
[questionid] =>
[answerA] =>
[answerB] =>
[answerC] =>
[comment] =>
[cid] => 86
[name] => EdvinasQ
[second_name] => LiutvaitisQ
[phone] => 12345678
[email] => ledvinas@yahoo.ie
)
[4] => stdClass Object (
[answerid] =>
[userid] =>
[questionid] =>
[answerA] =>
[answerB] =>
[answerC] =>
[comment] =>
[cid] => 87
[name] => Edvinas
[second_name] => Liutvaitis
[phone] => 123456
[email] => ledvinas@yahoo.ie
)
)

структура таблицы
учетные данные
cid(PRIMARY), name, second_name, phone, email

tblответы
answerid(PRIMARY), userid, questionid, answerA, answerB, answerC.


Подробнее здесь: https://stackoverflow.com/questions/152 ... odeigniter