Converting an app to CI (conceptualizing the breakdown)

[eluser]srajibtechno[/eluser]
Hello CI experts....

I am a new CI developer..starting to build a web based application.
I already created menu using css,php and my sql...but i can not implement it...with codeigniter..I already created model,controller and view files..for this application ..but i can not implement it perfectly ..can u help me...how can i do this??i want to use query1 and query2 in menu view file instead of result and result1(query1 and query2 come from menu_model file)....
I attached my code are shown below..

inbook_links.sql

CREATE DATABASE `inbook_db`;

CREATE TABLE `inbook_links` (
`menu_id` int(9) NOT NULL auto_increment,
`main_menu` varchar(150) collate latin1_general_ci NOT NULL,
`sub_menu` varchar(150) collate latin1_general_ci NOT NULL,
`menu_location` varchar(9) collate latin1_general_ci NOT NULL,
`menu_contents` varchar(255) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;




menu_model.php (Model file)

class Menu_model extends Model
{
function Menu_model()
{
parent :: Model();
}

function menu_getall()
{
$this->load->database();
$query = $this->db->query("SELECT * FROM inbook_links group by main_menu");
$query2 = $this->db->query("SELECT sub_menu FROM inbook_links");
return $query->result();
}
}

menu.php (Controller File)

class Menu extends Controller
{
function Menu()
{
parent :: Controller();
}

function GetAll()
{
$this->load->model('menu_model');
$data=array();
$data['query']=$this->menu_model->menu_getall();
$data['query2']=$this->menu_model->menu_getall();
$this->load->view('menu_view',$data);
}

}

menu_view.php (view file.)

<div class="mC">

&lt;!-- Main Menu Start --&gt;
&lt;?php
$menuID = 1;
while($val=mysql_fetch_array($result))
{
?&gt;
&lt;div class="mH" onmouseover="toggleMenu('&lt;?php echo 'menu'.$menuID; ?&gt;')"&gt;

</div>

&lt;? $result = mysql_query("SELECT sub_menu FROM inbook_links where main_menu='$row[main_menu]'");

?&gt;
<div id="&lt;?php echo 'menu'.$menuID; ?&gt;" class="mL" style="display:none;">
&lt;?php
while($val2=mysql_fetch_array($result2)){ ?&gt;<a class="mO" href="#">&lt;?php echo $val2['sub_menu']; ?&gt;</a>&lt;? } ?&gt;

</div>


&lt;!-- Main Menu End --&gt;
&lt;?php
$menuID++;
}
?&gt;

</div>

cheers...;-)
Regards.....

SRR