prepare("SELECT COUNT('id') FROM `staffcontacts` WHERE `DEPARTMENT` = 'ADVOCACY AND RESEARCH'") or die(mysqli_error()); $qtalisay->execute(); $talisay = $qtalisay->fetchAll(); foreach($talisay as $key => $row) { $total = $row["COUNT('id')"]; }?> query("SELECT COUNT('id') FROM `staffcontacts` WHERE `DEPARTMENT` = 'SERVICE DELIVERY'") or die(mysqli_error()); $qalijis->execute(); $alijis = $qalijis->fetchAll(); foreach($alijis as $key => $row) { $total1 = $row["COUNT('id')"]; }?> query("SELECT COUNT('id') FROM `staffcontacts` WHERE `DEPARTMENT` = 'FINANCE AND ADMIN'") or die(mysqli_error()); $qbinalbagan->execute(); $binalbagan = $qbinalbagan->fetchAll(); foreach($binalbagan as $key => $row) { $total2 = $row["COUNT('id')"]; }?> prepare("SELECT COUNT(DISTINCT bs_name) FROM tbl_personnel WHERE per_campus = 'Talisay' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edtbs = $row['COUNT(DISTINCT bs_name)']; }?> prepare("SELECT COUNT(DISTINCT ms_name) FROM tbl_personnel WHERE per_campus = 'Talisay' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edtms = $row['COUNT(DISTINCT ms_name)']; }?> prepare("SELECT COUNT(DISTINCT dr_name) FROM tbl_personnel WHERE per_campus = 'Talisay' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edtdr = $row['COUNT(DISTINCT dr_name)']; }?> prepare("SELECT COUNT(DISTINCT bs_name) FROM tbl_personnel WHERE per_campus = 'Fortune Towne' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edfbs = $row['COUNT(DISTINCT bs_name)']; }?> prepare("SELECT COUNT(DISTINCT ms_name) FROM tbl_personnel WHERE per_campus = 'Fortune Towne' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edfms = $row['COUNT(DISTINCT ms_name)']; }?> prepare("SELECT COUNT(DISTINCT dr_name) FROM tbl_personnel WHERE per_campus = 'Fortune Towne' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edfdr = $row['COUNT(DISTINCT dr_name)']; }?> prepare("SELECT COUNT(DISTINCT bs_name) FROM tbl_personnel WHERE per_campus = 'Alijis' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edabs = $row['COUNT(DISTINCT bs_name)']; }?> prepare("SELECT COUNT(DISTINCT ms_name) FROM tbl_personnel WHERE per_campus = 'Alijis' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edams = $row['COUNT(DISTINCT ms_name)']; }?> prepare("SELECT COUNT(DISTINCT dr_name) FROM tbl_personnel WHERE per_campus = 'Alijis' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edadr = $row['COUNT(DISTINCT dr_name)']; }?> prepare("SELECT COUNT(DISTINCT bs_name) FROM tbl_personnel WHERE per_campus = 'Binalbagan' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edbbs = $row['COUNT(DISTINCT bs_name)']; }?> prepare("SELECT COUNT(DISTINCT ms_name) FROM tbl_personnel WHERE per_campus = 'Binalbagan' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edbms = $row['COUNT(DISTINCT ms_name)']; }?> prepare("SELECT COUNT(DISTINCT dr_name) FROM tbl_personnel WHERE per_campus = 'Binalbagan' AND per_id<>0"); $display->execute(); $fetch = $display->fetchAll(); foreach($fetch as $key => $row) { $edbdr = $row['COUNT(DISTINCT dr_name)']; }?>