CodeIgniter Forums
double last record when using foreach($query->result() as $item) - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: double last record when using foreach($query->result() as $item) (/showthread.php?tid=10311)

double last record when using foreach($query->result() as $item) - El Forum - 07-26-2008

[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

double last record when using foreach($query->result() as $item) - El Forum - 07-26-2008

[eluser]Yash[/eluser]
Submit complete code

double last record when using foreach($query->result() as $item) - El Forum - 07-26-2008

[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>


double last record when using foreach($query->result() as $item) - El Forum - 07-26-2008

[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.

double last record when using foreach($query->result() as $item) - El Forum - 07-27-2008

[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!

double last record when using foreach($query->result() as $item) - El Forum - 07-28-2008

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

Thanks.