Попытка INNER JOIN нескольких таблиц к родительской таблице с помощью CodeIgniter не дает результатов [закрыто] ⇐ Php

[Anonymous]

Код: Выделить всё

function getReceiptData($receipt_id)
{
$this->db->select('class.name as cname,student.name as sname,student.father_name as fname,
student.student_parent_email rmail,student.address as raddress,admin.name as aname,fee_particular_name as pname,
fee_particular_discount as discount,fee_particular_amount as pamount,fee_category_id as cat_id, fee_collections.*');
$this->db->from('fee_collections');
$this->db->join('class', 'class_id = fee_collection_class_id');
$this->db->join('student', 'student_id = fee_collection_roll_id');
$this->db->join('fee_particulars', 'fee_particular_id = fee_collection_particular_id');
$this->db->join('admin', 'admin_id = fee_collection_added_by');
$this->db->where('fee_collection_id', $receipt_id);
$query = $this->db->get();
return $query->row();
}

почему это приведет к выдаче NULL?

Подробнее здесь: https://stackoverflow.com/questions/446 ... gniter-ret