$display_this_row = 0; $page = 0; $totals = array('TARGET_PLACES' => 0, 'TOTAL_PLACES' => 0, 'STUDENTS_ENROLLED' => 0, 'TARGET_SHORTFALL' => 0, 'MAXIMUM_SHORTFALL' => 0, 'ENROLLED_16_TO_18' => 0, 'ENROLED_OVER_19' => 0, 'ENROLLED_OVERSEAS' => 0); foreach ($my_records_courses->rows as $row) { if ($page != '') { if ($row_index >= $page * $rows_per_page) { $display_this_row = true; } else { $display_this_row = false; } } else { $display_this_row = true; } if ($display_this_row) { echo "<tr class=\"box\">"; echo " <td class=\"box\" style=\"text-align: center;\">" . $my_records_courses->show_blank($row[CENTRECODE]) . "</td>"; echo " <td class=\"box\" style=\"text-align: left;\">" . $my_records_courses->show_blank($row[COURSE_CODE]) . "</td>"; echo " <td class=\"box\" style=\"text-align: left;\">" . $my_records_courses->show_blank($row[COURSE_TITLE]) . "</td>"; echo " <td class=\"box\" style=\"text-align: right;\">" . $my_records_courses->show_blank($row[TARGET_PLACES]) . "</td>"; echo " <td class=\"box\" style=\"text-align: right;\">" . $my_records_courses->show_blank($row[TOTAL_PLACES]) . "</td>"; echo " <td class=\"box\" style=\"text-align: right;\">" . $my_records_courses->show_blank($row[STUDENTS_ENROLLED]) . "</td>"; echo " <td class=\"box\" style=\"text-align: right; background-color: #CCCCCC\">" . bracket_negative($my_records_courses->show_blank($row[TARGET_SHORTFALL])) . "</td>"; echo " <td class=\"box\" style=\"text-align: right;\">" . bracket_negative($my_records_courses->show_blank($row[MAXIMUM_SHORTFALL])) . "</td>"; echo " <td class=\"box\" style=\"text-align: right;\">" . $my_records_courses->show_blank($row[ENROLLED_16_TO_18]) . "</td>"; echo " <td class=\"box\" style=\"text-align: right;\">" . $my_records_courses->show_blank($row[ENROLLED_OVER_19]) . "</td>"; echo " <td class=\"box\" style=\"text-align: right; border-right: 1px solid #CCCCCC;\">" . $my_records_courses->show_blank($row[ENROLLED_OVERSEAS]) . "</td>"; echo "</tr>"; $totals[TARGET_PLACES] += $row[TARGET_PLACES]; $totals[TOTAL_PLACES] += $row[TOTAL_PLACES]; $totals[STUDENTS_ENROLLED] += $row[STUDENTS_ENROLLED]; $totals[TARGET_SHORTFALL] += $row[TARGET_SHORTFALL];