selecting distinct column in codeigniter

Vijay 20:51 distinct column selction in codeigniter

In CodeIgniter, you can select distinct columns from a database table using the Query Builder class or by writing raw SQL queries. Here, I'll show you how to do it using the Query Builder class.

Assuming you have already set up your CodeIgniter database connection as mentioned in the previous answer, you can use the following code to select distinct columns from a table:

Method 1 :

 
$this->db->distinct();

$this->db->select("column name");

Method 2 :

 
$this->db->select(DISTINCT(column name));

distinct column selction in codeigniter selecting distinct column in codeigniter