Dymanic navigation - URL question

[eluser]Otemu[/eluser]
Hi,

Quick example using your code above that should give you an idea that you can improve on:

Controller

Code:

//get segment from url
$getPage = $this->uri->segment(2);
//pass segment to model
$data['pages'] = $this->pages_model->get_page($getPage);

Model

Code:

public function get_page($getPage){
//query database for matching page title
  $query = $this->db->get_where('pages', array('page_title' => getPage));

index_view:

Code:

//display page title as url
foreach($pages as $row){
  echo "<ul>";
  echo "<li><a href="/page/">page_title.">/page/".$row->page_title." </a></li>";
  echo "</ul>";
}