How do you select what to chose as sort order, and direction of pagination?

[hossj]

I was wondering if we can select what to sort by and the sort order of pagination? Thanks.

[hossj]

I have added in the paginate function 2 more variable $sort_by and $order_by which resolves this problem. Let me know if of interest and will send to you.

[avenirer]

don't you have the order_by() method?

[ardianta]

the order_by() function does not work.

$query = $this->user_model->order_by("user_id","DESC");
$query->paginate(10, $query->count->rows());

it still display ASC order

[andrehardika]

I tried it too, and it's not working