[eluser]jordantkj[/eluser]
Hi,
The following code is not returning DISTINCT item values. If I run this query from phpmyadmin, it works as expected. Any ideas? Is there at least a way to echo out the query string provided to mysql?
Code:
$this->db->distinct('item');
$this->db->join('chassis_support', 'chassis_support.part_num = component.part_num', 'inner');
$query = $this->db->get('component');
if ($query->num_rows() > 0) {
foreach($query->result() as $row) {
echo 'Query Result: ' . $row->item . '</br>';
}
}
OUTPUT:
Query Result: Midplane
Query Result: Power Supply
Query Result: Power Supply
Query Result: CFEB
Query Result: Fan Tray
Query Result: Midplane
Query Result: FPM GBUS
Query Result: FPM Display
Query Result: CIP
Query Result: PEM
Query Result: PEM
Query Result: SCG
Query Result: SCG
Query Result: CB
Query Result: CB
Query Result: SPMB
Query Result: SPMB
Query Result: SIB
Query Result: SIB
Query Result: SIB
Query Result: Fan Tray
Query Result: Fan Tray
Query Result: Fan Tray