Roscoe posted

Ordering active record alphabetically in Codeigniter

sec8
answered Apr 27 '23 00:00

To order an Active Record alphabetically in CodeIgniter, you can use the $this->db->order_by() method with the column name and the sorting direction.

Here's an example of how to order an Active Record alphabetically in ascending order:



$this->db->select('*');
$this->db->from('my_table');
$this->db->order_by('my_column', 'ASC');
$query = $this->db->get();

In this example, we are selecting all columns from a table named "my_table" and ordering the results by the " my_column " column in ascending alphabetical order.

To order the Active Record in descending order, you can change "ASC" to "DESC" like this:


$this->db->select('*');
$this->db->from('my_table');
$this->db->order_by('my_column', 'DESC');
$query = $this->db->get();

In this example, we are selecting all columns from a table named " my_table " and ordering the results by the " my_column " column in descending alphabetical order.

You can modify the example to suit your specific query needs, changing the table name and column name as necessary. Note that when ordering alphabetically, uppercase letters come before lowercase letters in ascending order.

Edit Answer

Roscoe posted

Ordering active record alphabetically in Codeigniter

sec8 answered Apr 27 '23 00:00

Latest Questions

Insert link

Insert image

sec8
answered Apr 27 '23 00:00