[PHP CodeIgniter Dynamic navigation]

can anyone please help me

[PHP CodeIgniter Dynamic navigation]

Controller:

 

<?php
function gui()
{
	$nav = $this->site_model->navigation();
	$page = $this->site_model->page_config();
	$this->load->view('site/site',array('page' => $page, 'nav'=> $nav));	
}
?>

 

Model:

 

<?php

function navigation()
{	

	// Parent Menu

	$this->db->order_by('order', 'asc');
        $this->db->where('subid', '0');
        $query = $this->db->get('navigation');

	$i = 0;

	foreach($query->result() as $row)
	{

		$parentitem[$i]['id'] = $row->id;
		$parentitem[$i]['link'] = $row->link;
		$parentitem[$i]['title'] = $row->title;

		// Sub Menu

		$this->db->order_by('order', 'asc');
		$this->db->where('subid', $parentitem[$i]['id']);
		$subquery = $this->db->get('navigation');

		$sub = 0;

		foreach($subquery->result() as $row)
		{

			$subitem[$sub]['id'] = $row->id;
			$subitem[$sub]['link'] = $row->link;
			$subitem[$sub]['title'] = $row->title;

			$sub++;

		}

		$i++;
	}

	$nav;
	$nav = array();

	$nav['parent'] = $parentitem;
	$nav['sub'] = $subitem;

	return $nav;
}
?>

 

View:

 

<?php
foreach($nav['parent'] as $parent)
	{
		echo '<h3><a name="'.$parent['link'].'">'.$parent['title'].'</a></h3>';
		echo '<div>';
		echo '<ul>';
		foreach($nav['sub'] as $subitem)
		{

			echo '<li><a name="'.$subitem['link'].'">'.$subitem['title'].'</a></li>';

		}
		echo '</ul>';
		echo '</div>';

	}
?>

 

the script works for the parent navigational links but not the sub links it keeps repeating the last subitem from the db

 

I only posted the relivant portion of code