Using IN statement in CodeIgniter query() [duplicate]

Question

So I have this method to retrieve my data:

    public function retrieve_not_members($group_id){
        $sql= "SELECT * FROM pnp_officer_tbl WHERE pnp_id NOT IN (SELECT pnp_id FROM group_members_tbl WHERE group_id = ?)";
        $this->db->query($sql, array($group_id));       

        echo $this->db->last_query();

        $query = $this->db->get();
        $data = $this->return_data($query);
        var_dump($data);
        }

It returned false. However, when i tried to query the returned string by $this->db->last_query(); directly in my database it is working properly. Why is that so?

This is the query string returned:

SELECT * FROM pnp_officer_tbl WHERE pnp_id NOT IN (SELECT pnp_id FROM group_members_tbl WHERE group_id = 'GROUP-0002')

I am looking for answers for almost 1 hour now. Thank you!

Kevin · Accepted Answer · 2015-04-11 11:10:56Z

2

No, the $this->db->get() is superfluous since you already made an $this->db->query(). After the ->query() method, return the response thru ->result():

public function retrieve_not_members($group_id)
{
    $sql = "SELECT * FROM pnp_officer_tbl WHERE pnp_id NOT IN (SELECT pnp_id FROM group_members_tbl WHERE group_id = ?)";
    $query = $this->db->query($sql, array($group_id));       
    return $query->result();
}

answered Apr 11, 2015 at 11:10

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using IN statement in CodeIgniter query() [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related