FTWwings FTWwings - 25 days ago 16
PHP Question

Codeigniter order_by name not working

So I am pulling 10 records from database at the time using AJAX call.

below is my code:

public function get_next_10($offset = 0)
{
$this->db->limit(15, $offset);
$query = $this->db->get("postovi");
return $query->num_rows() > 0 ? $query->result_array() : NULL;
}


I tried putting:

$this->db->order_by("name", "asc");


but it's throwing an error.

Answer

Its Working Fine

public function get_next_10($offset = 0)
{
$this->db->limit(15, $offset);
$this->db->order_by('name', 'asc');
$query = $this->db->get("postovi");
return $query->num_rows() > 0 ? $query->result_array() : NULL;
}
Comments