<div id="statistics">
                    <h1>Statistics</h1>
                    <table style="border: 1px solid #ccc; margin-left: auto; margin-right: auto; width: 800px;">
                      <tr>
                        <td style="width: 300px; text-align: left; padding-left: 10px; font-size: 14px; background-color: #6699cc; color: #ffffff">Customer Center</td>
<?php

$sql_get_cert = "SELECT cert_id, caption FROM certificates ORDER BY cert_id ASC";
$get_cert = $PDODB->prepare($sql_get_cert);
$get_cert->execute();
$certdata = $get_cert->fetchAll();

foreach ($certdata as $cert) {
     echo '                        <td style="padding-left: 10px; padding-right: 10px; font-size: 14px; background-color: #6699cc; color: #ffffff">' . $cert['caption'] . '</td>' . "\n";
}

?>
                        <td style="padding-left: 10px; padding-right: 10px; font-size: 14px; background-color: #6699cc; color: #ffffff">Staff count</td>
                      </tr>
<?php

$staffcount = 0;
$sql_get_ccdata = "SELECT cc_id, cc_name, cc_code FROM ccdata ORDER BY cc_name ASC";
$get_ccdata = $PDODB->prepare($sql_get_ccdata);
$get_ccdata->execute();
$ccdata = $get_ccdata->fetchAll();

$i = 0;

foreach ($ccdata as $cc) {
     $sql_get_ccstaff = "SELECT staff_id FROM staff WHERE cc_id = '" . $cc['cc_id'] . "'";
     $get_ccstaff = $PDODB->prepare($sql_get_ccstaff);
     $get_ccstaff->execute();
     $ccstaff = $get_ccstaff->fetchAll();

     $cc_staffcount = 0;

     foreach ($ccstaff as $staff) {
          $ccstaff_certcount_totals = 0;
          foreach ($certdata as $cert) {
               $staff_certcount = $PDODB->query("SELECT COUNT(*) FROM rel__staff_certificate WHERE staff_id = '" . $staff['staff_id'] . "' AND cert_id = '" . $cert['cert_id'] . "'")->fetchColumn();

               if ($staff_certcount > 0) {
                    $ccstaff_certcount_totals += $staff_certcount;
               }
          }

          $cc_staffcount++;
     }

     if ($i % 2) { $bgcolor = ''; } else { $bgcolor = '#eee'; }




     echo '                      <tr>' . "\n";
     echo '                        <td style="width: 300px; text-align: left; padding-left: 10px; background-color: ' . $bgcolor . '">' . $cc['cc_name'] . ' (' . $cc['cc_code'] . ')</td>' . "\n";

     foreach ($certdata as $cert) {
          echo '                        <td style="padding-left: 10px; padding-right: 10px; background-color: ' . $bgcolor . '">' . $ccstaff_certcount_totals . '</td>' . "\n";
     }

     echo '                        <td style="padding-left: 10px; padding-right: 10px; background-color: ' . $bgcolor . '">' . $cc_staffcount . '</td>' . "\n";
     echo '                      </tr>' . "\n";

     $i++;

     $staffcount += $cc_staffcount;
}

?>
                      <tr>
                        <td style="width: 300px; text-align: left; padding-left: 10px; font-size: 14px; background-color: #6699cc; color: #ffffff">Totals:</td>
<?php

foreach ($certdata as $cert) {
     echo '                        <td style="padding-left: 10px; padding-right: 10px; font-size: 14px; background-color: #6699cc; color: #ffffff">0</td>' . "\n";
}

?>
                        <td style="padding-left: 10px; padding-right: 10px; font-size: 14px; background-color: #6699cc; color: #ffffff"><?php echo $staffcount; ?></a></td>
                      </tr>
                    </table>
                  </div>