FTWwings FTWwings - 1 month ago 17
PHP Question

Order data by name?

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

The code goes like this:

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 breaks.

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;
}