<?php  
//Check for sessions and allow session data retreival and use
if(!isset($_SESSION)) {
session_start();
}

include_once('fnect.php');// connect db
//require_once('errors.php'); // get errors
//require_once('success.php'); // return success messages

$act = $_GET['fpe'];
	
/********** School Management *************/
$sccp = "SELECT Schools, SchCode FROM fpe_schools where SchCode = '$act'";
$sddb = mysqli_query( $fpecon, $sccp) or die(mysqli_errno());
while ($row = mysqli_fetch_array($sddb))
{
	$scc = stripslashes($row['Schools']);
}

/********** Attend to School/Department Issues *************/
$schdept = "SELECT Departments, DeptCode FROM fpe_schools where SchCode = '$act'";
$sdb = mysqli_query( $fpecon, $schdept) or die(mysqli_errno());

/********** Department against Schools *************/
$sdept = "SELECT Departments, DeptCode FROM fpe_schools where SchCode = '$act'";
$sdpt = mysqli_query( $fpecon, $sdept) or die(mysqli_errno());

/********** Department against Schools *************/
	$dpmt = "SELECT SchCode, Departments, Schools FROM fpe_schools where DeptCode = '$act'";
	$scdt = mysqli_query( $fpecon, $dpmt) or die(mysqli_errno());
	while ($row = mysqli_fetch_array($scdt))
	{
		$schs = stripslashes($row['Schools']);
		$scode = strtolower(stripslashes($row['SchCode']));
		$ddpt = stripslashes($row['Departments']);
	}

?>