'Bill to', 'SHIPTO' => 'Ship to', 'IMPRINT' => 'Imprint', 'ARTIST' => 'Artist', 'RELEASE_NAME' => 'Release', 'SKU' => 'SKU', 'OH' => 'OH', 'ON_PO' => 'ON PO', 'RETURNS' => 'Returns', 'PROJECTED_OH' => 'Projected OH', 'OPEN_ORDERS_QTY' => 'Open Orders Quantity', 'OPEN_ORDERS_PRCE' => 'Open Orders Price', 'SHIP_QTY' => 'Ship Quantity', 'SHIP_PRCE' => 'Ship Price', 'RTN_QTY' => 'Return Quantity', 'RTN_PRCE' => 'Return Price', 'NET' => 'Net Quantity', 'NET_PRCE' => 'Net Price', 'RTN_PER' => 'Return %', ); $sqlAlias = array_intersect_key($colNames, $this->breakdown[0]); $dataTable = ' '; foreach ($this->breakdown as $row) { foreach (array_keys($sqlAlias) as $k) { // Translate column names if ($k == 'SHIPTO') { $row2[ $colNames[$k] ] = str_replace(Model_B2bPhysicalView::SHIPTONAME_SEPARATOR, ' - ', $row[$k]); } elseif ($k == 'SKU') { $row2[ $colNames[$k] ] = " {$row[$k]}"; } else { $row2[ $colNames[$k] ] = $row[$k]; } } // output data $dataTable .= ' '; } $dataTable .= '

' . implode('	', $sqlAlias) . '
'.implode('	', $row2).'

'; echo $dataTable;