double last record when using foreach($query->result() as $item)

[eluser]Galford[/eluser]
Hi

I have something like that

in $query is simple select * from table

Code:

foreach($query->result() as $item)
{
    $content .= $this->load->view('contact_element_show', $item, true);
}

when I check the result its double last row from table.

Is it a bug?

I use CI 1.6.3

Regards

[eluser]Yash[/eluser]
Submit complete code

[eluser]Galford[/eluser]
ok

Model

Code:

function get_all()
    {
        $this->db->order_by('Parameter', 'ASC');
        return $this->db->get('ContactMain');
    }

Controller

Code:

function index()
    {
        $content = "<div class='m_ftp'>Main Contact</div>";
        
        $query = $this->CMM->get_all();
        
        $content .= '<table cellpadding="2" cellspacing="2" align="center" width="100%">';
        
        foreach($query->result() as $item)
        {
            $content .= $this->load->view('Admin/contactmain_show', $item, true);
        }
        
        $content .= $this->load->view('Admin/contactmain_show', $query, true);
        
        $content .= '</table>';
        $this->response['content'] = $content;
        $this->load->view('Admin/index', $this->response);
    }

View:

Code:

<tr>
    <td align="right" class="m_main" width="150px">&lt;?= $Parameter; ?&gt;</td>
    <td align="left">&lt;?= $Value; ?&gt;</td>
    <td width="150px" align='left'>&lt;?= anchor(site_url('Admin/contactmain/edit/'.$Parameter), 'Edit '.$Parameter, 'id="black"'); ?&gt;</td>
</tr>

[eluser]Galford[/eluser]
I see the problem, sorry for bother U.

Just stupid mistake in Controller.

Code:

$content .= $this->load->view('Admin/contactmain_show', $query, true);

Please delete this post.

Regards.

[eluser]Derek Allard[/eluser]
Hey Galford, I'll delete this post if you want me to, but I'd much rather we kept it here in case another user ever finds themselves in the same situtation. Any objection to me just leaving it standing?

Oh, and welcome to CodeIgniter!

[eluser]Galford[/eluser]
Ok, keep it here.

Thanks.