Welcome Guest, Not a member yet? Register   Sign In
$resultsALL->list_fields() returns more fields than $resultsALL->result_array()

Hi -  I have an interesting result.  We are on Codeigniter 3.1.11.  I am running a query with a join, and the field that I'm using to join is returned twice in the list_fields() call but only once in the result_array().
Is this expected?  I'm writing a CSV with headers and now there's an extra column which has no data.
This is my code: 
$fullQry = "SELECT * FROM tblProgram O1 JOIN (SELECT `pkProgramID`
FROM `tblProgram`
JOIN `tblPlots` ON `tblPlots`.`programID`=`tblProgram`.`pkProgramID`
JOIN `tblTrees` ON `tblTrees`.`_nefin_plotID`=`tblPlots`.`_nefin_plotID`
GROUP BY `pkProgramID`) AS O2 ON O1.pkProgramID=O2.pkProgramID GROUP BY O1.pkProgramID";

$resultsALL= $this->db->query($fullQry);

//open filestream for program data
if (!$program_handle){
    show_error('could not open hand for program data');
//put headers into CSV
fputcsv($program_handle, $programData['fields']);
//put  data into CSV       
foreach ($programData['data'] as $line) {
    fputcsv($program_handle, $line, ',', '"' , '');                         

Theme © iAndrew 2016 - Forum software by © MyBB