A PHP Error was encountered. Unknown: 1 result set(s) not freed

[eluser]jiahui[/eluser]
I am codeIgniter newbie. Any expert can tell me what's going on I keep get following error messages? I found a similiar problem solution in this forum. But I wonder why I even no include this "mysql_free_result($query);" code. How come I still get this following error?

A PHP Error was encountered

Severity: Warning

Message: Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()

Filename: Unknown

Line Number: 0


My code is

$this->db->where('groupid = 1');
$this->db->order_by('lastname','asc');
$accounts = $this->db->get('user');


<?php foreach($accounts->result() as $user):?>
<li>
&lt;?php echo $user->firstname.' '.$user->lastname.' ('.$user->email.')';?&gt;
</li>
&lt;?php endforeach;?&gt;

[eluser]imn.codeartist[/eluser]
change your

Code:

$this->db->where(‘groupid = 1’);

To

Code:

$this->db->where('groupid',1);

and try

[eluser]jiahui[/eluser]
Thanks for your reply. But it does not works. Any comments from others?

[eluser]Haskabab[/eluser]
The function mysql_free_result( /* query var */ ) usually does the job.

But I aswell can't figure out how to implement it with the active record class correctly. So if anyone does know, please post!

I'll be watching this topic.

[eluser]InsiteFX[/eluser]
This is how you free_result!

Code:

function get_all()
{
    $data = array();

    $query = $this->db->get('table_name');

    if ($query->num_rows() > 0)
    {
        foreach ($query->result_array() as $row)
        {
            $data[] = $row;
        }
    }

    $query->free_result();
    return $data;
}

InsiteFX