Query not work in CodeIgniter

Question

function menuName () 
{
    $this->viewData['page_title'] = "ContentManagement Systemt!";


    $this->db->where('visible', 1);
    $this->db->order_by("position", "ASC"); 
    $query = $this->db->get('subjects');
    $subjects = $query->result();
    foreach ($subjects as $subject)
    {
        echo $subject->menu_name ."<br />";

        $this->db->where('subject_id', $subject->id );
        $query = $this->db->get('pages');
        $pages = $query->result();

        foreach ($pages as $page)
        {
            echo $page->menu_name ."<br />";
        }        
    }

}

Why not working my query pls tell me anyone

Answer 1

You should always use foreach loops like the following:

$subjects = $query->result();
foreach ($subjects as $subject)

Your approach has a bad performance.

And maybe this already solves your problem - I couldn't test it right now . Your query variables are named equally and you're using $query in both of your foreach loops - this could maybe lead to some strange behaviour.