Sorting Database columns using codeigniter

[eluser]Nicholai[/eluser]
What about something like this:

Code:

function index($sort = NULL , $direction = NULL)
   {
      $data['title'] = "First Down Statistics";
      $this->db->orderby($sort, $direction);
      $data['query'] = $this->db->get('firstdown');
      $this->load->view('firstdown', $data);
   }

Then you can pass the sort field and direction back to the controller again to reload the page with sorted results.

Code:

<?php echo anchor('FirstDown/index/Name/asc','Name) ?>

I'm a new guy and speculating a bit without testing, and you'll need some logic to figure out ascending vs descending, but maybe it will get you closer to what you want.