Fatal error: Call to a member function row_array() on boolean

Question

Please i have an issue with codeigniter. when i try to log here is the result

Below is the my code :

    $sub_and = '';

    if($this->location_parent == 0){
        $sub_and = "and g.idlocation_fk IN (".$locids.")";
    }else{
        $sub_and = "and g.idlocation_fk IN (".$locids.")";  
    }


    if(($this->session->userdata("user_group_fk") == 1) || ($locids == '')){
        $sub_and = '';
    }       


$sql = "select GROUP_CONCAT(DISTINCT(g.idgroup)) as group_id 
            FROM groups g
            JOIN group_users gu ON gu.idgroup_fk = g.idgroup
            WHERE gu.status = 0 and gu.iduser_fk = $iduser $sub_and";

    $results = $this->db->query($sql);
    $results = $results->row_array();
    return $results;

pls always response to the answers by giving some comments or ,if it helps you, by marking it as green and upvoting, it is the best way to thanks all the programmers — Pradeep, Jul 28 '18 at 14:46

score 0 · Answer 1 · answered Jul 25 '18 at 12:49

0

you have error in concatenation. try with following.

$sql = "select GROUP_CONCAT(DISTINCT(g.idgroup)) as group_id FROM groups g JOIN group_users gu ON gu.idgroup_fk = g.idgroup WHERE gu.status = 0 and gu.iduser_fk = $iduser." ".$sub_and";

answered Jul 25 '18 at 12:49

Alpa Bhanderi

41
2

Hi thank you for your answer but its not working for me – selvakumar mariappan Jul 25 '18 at 13:34
try to run your query in phpmyadmin and let me know what error you are getting. – Alpa Bhanderi Jul 25 '18 at 13:41
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '" ".$sub_and" LIMIT 0, 25' at line 1 – selvakumar mariappan Jul 26 '18 at 05:46

Pradeep · Answer 2 · 2018-07-25T14:26:24.507

Hope this will help you :

Make sure $iduser is available in your method and $locids should be an array of values

$this->db->select('GROUP_CONCAT(DISTINCT(g.idgroup)) as group_id');
$this->db->from('groups g');
$this->db->join('group_users gu', 'gu.idgroup_fk = g.idgroup');

$this->db->where('gu.status', '0');
$this->db->where('gu.iduser_fk', $iduser);

/* $locids must be an array like $locids = array(1,3,4);*/
if (! empty($locids))
{
   $this->db->where_in('g.idlocation_fk', $locids);   
}

$row = $this->db->get()->row_array();
print_r($row);

For more : https://www.codeigniter.com/user_guide/database/query_builder.html

Fatal error: Call to a member function row_array() on boolean

2 Answers2