getting nav from category table

Yii 1.1 General Discussion
1

I want my navigation in front-end fetched from category table of my database. How can i do it in yii ?

2

here you go




<nav id="site-navigation">

	<ul>

	<?php foreach (CategoryModel::model()->findAll() as $category): ?>

		<li><?php echo $category->name ?></li>

	<?php endforeach ?>

	</ul>

</nav>

<!-- /site-navigatin -->
3

Thanks :) it worked all fine , now i want to get all my data from “page” table sorted with category. I have this two tables first category and other page, category_id = foreign key in my page table now i want to fetch data from foreign key as it is in navigation how can i do it?

4

Thanks :) it worked all fine , now i want to get all my data from “page” table sorted with category. I have this two tables first category and other page, category_id = foreign key in my page table now i want to fetch data from foreign key as it is in navigation how can i do it?