Iterating over columns

Original - php Code $rows = 0; $cols = 0; $rows = mysql_num_rows ($result); $cols = mysql_num_fields ($result); $colNames = array(); for ($col = 0; $col < $cols; $col++) { $colNames[col] = mysql_field_name($result, $col); } // Add all the column headings with a single call $sheet->writeRow(5,0,$colNames,$colHeadingFormat); $colHeadingFormat2 =& $xls->addFormat(); $colHeadingFormat2->setFontFamily('Helvetica'); $colHeadingFormat2->setSize('10'); $colHeadingFormat2->setAlign('center'); for ($row = 0; $row < $rows; $row++) { $rs = mysql_fetch_row ($result); for ($col = 0; $col < $cols; $col++) { $sheet->write($row+6,$col,$rs[$col],$colHeadingFormat2); } }

 
$rows = 0;
       $cols = 0;
       $rows = mysql_num_rows ($result);
       $cols = mysql_num_fields ($result);
 
        $colNames = array();
 
        for ($col = 0; $col < $cols; $col++)
        {
        $colNames[col] = mysql_field_name($result, $col);
     }
 
     // Add all the column headings with a single call
     $sheet->writeRow(5,0,$colNames,$colHeadingFormat);
 
     $colHeadingFormat2 =& $xls->addFormat();
     $colHeadingFormat2->setFontFamily('Helvetica');
     $colHeadingFormat2->setSize('10');
     $colHeadingFormat2->setAlign('center');
 
        for ($row = 0; $row < $rows; $row++)
        {
              $rs = mysql_fetch_row ($result);
        for ($col = 0; $col < $cols; $col++)
        {
                $sheet->write($row+6,$col,$rs[$col],$colHeadingFormat2);
              }
        }