Witam. Mam problem ze zwroceniem danych do widoku przy joinie. Prosze o pomoc
kod modelu wyglada nastepujaco:
function get_userdata($usr)
{
$query = $this->db->query("select * from users u
join address a on u.USR_ID = a.USERS_USR_ID
join client c on a.ADDR_ID = c.Address_ADDR_ID where u.USR_Nick = '".$usr."'")->result();
return $query;
}
kod kontrolera:
function get_userdata()
{
$usr = $this->session->userdata('username');
$widok['left'] = $this->get_category();
$widok['right'] = $this->load->view('Ksiegarnia/right', '', true);
$query = $this->Users_model->get_userdata($usr);
if($query->num_rows() >0)
{
$item = $query->row();
$widok['center'] = $this->load->view('Ksiegarnia/get_userdata_view', $item, true);
}
$this->load->view('Ksiegarnia/index_logged', $widok);
}
po wykonaniu funkcji wyskakuje mi blad: Fatal error: "Call to a member function num_rows() on a non-object in..."