Order By Method
Order By method is part of database class builder for sorting result query.
Parameters
Insert method has 2 required parameters that is column name and sort direction.
$this->db->group_by(string $column_name, string $sort_direction): dbObject
$column_name
Column Name can be filled by column name or function string.
$sort_direction
Sort Direction value consist of asc and desc. "asc" for ascending and "desc" for descending
Example usage
Here is the examples using order_by method. See the first of this page for full example.
Basic Usage
For example we assumed want to add new data in blog table. First, in the model:
<?php
class Blog_Model extends SENE_Model{
var $tbl = 'blog';
var $tbl_as = 'b';
public function __construct(){
parent::__construct();
}
public function getLatest($di){
$this->db->order_by("create_date","desc");
return $this->db->get();
}
}