[eluser]debow[/eluser]
This is the controller code.
Code:
var $data;
function index($sort_by = 'eorder', $sort_order = 'asc', $offset = 0) {
$limit = 10;
$data['fields'] = array(
'rank' => 'Rank',
'score' => 'Points',
); //The above will be sortable columns
$ranks = $this->rank_model->get_scoring($limit, $offset, $sort_by, $sort_order);
$data['scores'] = $ranks['rows'];
$data['num_results'] = $ranks['num_rows'];
$data['num_pages'] = $data['num_results']/$limit;
// pagination
$this->load->library('pagination');
$config = array();
$config['base_url'] = site_url("home/index/$sort_by/$sort_order");
$config['total_rows'] = $data['num_results'];
$config['per_page'] = $limit;
$config['uri_segment'] = 5;
$this->pagination->initialize($config);
$data['pagination'] = $this->pagination->create_links();
$data['sort_by'] = $sort_by;
$data['sort_order'] = $sort_order;
$this->load->view('includes/header', $this->data);
$data['main_content'] = 'home/home_index';
$this->load->view('includes/template', $data);
}
This is the view code
Code:
<ul><li>
<div id="tableside" class="tableside">
<table>
<tbody>
<?php foreach ($fields as $field_name => $field_display): ?>
<th>
<?php if ($sort_by == $field_name)
echo "class=\"sort_$sort_order\"" ?>
<?php
echo anchor("home/display/$field_name/" .
(($sort_order == 'asc' && $sort_by == $field_name) ? 'desc' : 'asc'), $field_display);
?>
</th>
<?php endforeach; ?>
<?php foreach ($scores as $cmd): ?>
<tr>
<?php foreach ($fields as $field_name => $field_display): ?>
<td><?php echo $cmd->$field_name; ?></td>
<?php endforeach; ?>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div></li>
<li>
<div id='pages' align='center'>
<?php if (strlen($pagination)): ?>
Pages:
<?php echo $pagination; ?>
<?php endif; ?>
</div>
</li>
</ul>
Thanks for any help.