Not getting DISTINCT values from query

[eluser]Bhashkar Yadav[/eluser]
plz try this

Code:

$this->db->distinct();
$this->db->select('item');
$this->db->join('chassis_support', 'chassis_support.part_num = component.part_num', 'inner');
$query = $this->db->get('component');

OR

Code:

$this->db->select('DISTINCT(item)');
$this->db->join('chassis_support', 'chassis_support.part_num = component.part_num', 'inner');
$query = $this->db->get('component');