session_start();
$sessionid = session_id();
#error_reporting(0);
$db_info["username"] = "szost_scsbcdb"; // enter username for the database
$db_info["password"] = "sCS5b,.("; // enter password for the database
$db_info["host"] = "localhost"; // enter the host address or leave as local
$db_info["dbname"] = "szostak_scsbc"; // enter the name of the database
$profileFileTypes=Array('jpg','jpeg','png')
?>
# this might not be needed anymore, but we'll keep it just incase.
$tabledInCheck = "Tables_in_".$db_info["dbname"];
//$db_connection = mysql_connect($db_info["host"], $db_info["username"], $db_info["password"]) or die (mysqli_error());
//mysql_select_db($db_info["dbname"], $db_connection) or die (mysqli_error());
global $mysqli;
$mysqli = mysqli_connect($db_info["host"], $db_info["username"], $db_info["password"]);
mysqli_select_db($mysqli,$db_info["dbname"]);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
function mirage_nocache($sql_query)
{
global $db_connection;
global $db_type;
global $mysqli;
$mirage_resultValue = '';
$result = mysqli_query($mysqli,"$sql_query", $db_connection);
if(is_bool($result)){
if($result) return $result;
else {
echo mysqli_error($db_connection);
}
} else {
$mirage_resultValue= array();
while ($row = mysqli_fetch_array($result)) {
$num_of_fields = mysqli_num_fields($result);
for($k==0;$k<$num_of_fields;$k++){
$field_name = mysqli_fetch_field_direct($result, $k);
$name=$field_name->name;
$value = $row["$name"];
$mirage_resultValue[$name] = $value;
}
}
}
return $mirage_resultValue;
}
function mirage_dbdo($sql_query, $sql_command_type, $alert="0"){
if ($alert==1)
{
print $sql_query." ";
}
global $db_connection;
global $db_type;
global $arrSQLCache;
global $mysqli;
if ($sql_command_type == "SELECT"){
if (!$arrSQLCache[$sql_query])
{
$k=0;
$mirage_resultValue=null;
$result = mysqli_query($mysqli,"$sql_query");//or die("
Query failed: dbdo $sql_query
");
while ($row = mysqli_fetch_array($result)) {
$num_of_fields = mysqli_num_fields($result);
for($k==0;$k<$num_of_fields;$k++){
$field_name = mysqli_fetch_field_direct($result, $k);
$name=$field_name->name;
$value = $row["$name"];
$mirage_resultValue[$name] = $value;
}
}
$arrSQLCache[$sql_query]=$mirage_resultValue;
} else {
$mirage_resultValue = $arrSQLCache[$sql_query];
}
return $mirage_resultValue;
}
if ($sql_command_type == "INSERT"){
}
if ($sql_command_type == "DELETE"){
}
$query = "$sql_query";
mysqli_query($mysqli,$query);
return true;
}
function mirage_multi($sql_query, $indexValue=1, $alert="0"){
if ($alert==1)
{
print $sql_query." ";
}
global $db_type;
global $arrSQLCache;
global $mysqli;
if (!$arrSQLCache[$sql_query])
{
$result = mysqli_query($mysqli,"$sql_query")or die("
Query failed: multi $sql_query
");
$a = 0;
$requestedValue = $indexValue - 1;
while ($row = mysqli_fetch_array($result)) {
$getFieldName = mysqli_fetch_field_direct($result, $requestedValue);
$name=$getFieldName->name;
$value = $row["$name"];
$requestedArray[$value] = $row;
$a++;
}
$arrSQLCache[$sql_query]=$requestedArray;
} else {
$requestedArray = $arrSQLCache[$sql_query];
}
return $requestedArray;
}
/**
fixes bug that over-writes non-unique data
**/
function mirage_multi_unique($sql_query, $indexValue=1, $alert="0"){
if ($alert==1)
{
print $sql_query." ";
}
global $db_type;
global $arrSQLCache;
global $mysqli;
if (!$arrSQLCache[$sql_query])
{
$result = mysqli_query($mysqli,"$sql_query")or die("
Query failed: multi $sql_query
");
$a = 0;
$requestedValue = $indexValue - 1;
while ($row = mysqli_fetch_array($result)) {
$requestedArray[$a] = $row;
$a++;
}
$arrSQLCache[$sql_query]=$requestedArray;
} else {
$requestedArray = $arrSQLCache[$sql_query];
}
return $requestedArray;
}
?>
$instructorEmail = "mike@pacificnewmedia.com";
//$instructorEmail = "tim@bgcpartners.ca";
date_default_timezone_set('America/Vancouver');
//TO DO - record IP in history table to see possible abuse or attacks?
function saveHistory($strDetails)
{
mirage_dbdo("INSERT INTO history SET strName='".mysql_real_escape_string($_GET["page"])."',strDetails='".mysql_real_escape_string($strDetails)."'","INSERT");
}
function dollar_format($amount, $places = 2)
{
if($places != 2){
// different format:
return money_format("$%.{$places}i",$amount);
}
return money_format('$%i',$amount);
}
function get_password($length=8)
{
$chars = 'abcdefghijklmnopqrstuvwxyz0123456789';
$count = mb_strlen($chars);
for ($i = 0, $result = ''; $i < $length; $i++) {
$index = rand(0, $count - 1);
$result .= mb_substr($chars, $index, 1);
}
return $result;
}
function getDaysInBetween($start, $end) {
// Vars
$day = 86400; // Day in seconds
$format = 'Y-m-d'; // Output format (see PHP date funciton)
$sTime = strtotime($start); // Start as time
$eTime = strtotime($end); // End as time
$numDays = floor(($eTime - $sTime) / $day) + 1; // add 2, one for day 1 and one
$days = array();
// Get days
for ($d = 0; $d < $numDays; $d++) {
$days[date($format, ($sTime + ($d * $day)))]["date"] = date($format, ($sTime + ($d * $day)));
}
// check for last day:
if(!isset($days[$end])){$days[$end]["date"]=$end;}
// Return days
return $days;
}
function mysql_real_escape_string($val)
{
global $mysqli;
$returned=mysqli_real_escape_string($mysqli,$val);
return $returned;
}
function mysql_error()
{
global $mysqli;
$returned=mysqli_error($mysqli);
return $returned;
}
function mysql_insert_id()
{
global $mysqli;
$returned=mysqli_insert_id($mysqli);
return $returned;
}
//get average of all big6 schools for specified db field
function get_big6($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=4 AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field
function get_k12($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=3 AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field
function get_smallk12($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=2 AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field
function get_k8($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=1 AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field
function get_all($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks WHERE schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all big6 schools for specified db field FTE
function fte_big6($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=4 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field FTE
function fte_k12($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=3 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field FTE
function fte_smallk12($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=2 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field FTE
function fte_k8($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=1 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field FTE
function fte_all($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN schoolbenchmarks ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all big6 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_big6_nozero($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=4 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_k12_nozero($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=3 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_smallk12_nozero($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=2 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_k8_nozero($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE users.nSizeID=1 AND stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_all_nozero($field)
{
global $schoolbenchmark;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN schoolbenchmarks ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."' WHERE stafffte.nBenchmarksID='".$arrBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
/******************************************************
Previous year functions
Functions for the previous year, same as above but for the year before
*****************************************************/
//get average of all big6 schools for specified db field
function get_big6_previous($field)
{
global $schoolbenchmark_previous;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=4 AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field
function get_k12_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=3 AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field
function get_smallk12_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=2 AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field
function get_k8_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=1 AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field
function get_all_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks WHERE schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all big6 schools for specified db field FTE
function fte_big6_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=4 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field FTE
function fte_k12_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=3 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field FTE
function fte_smallk12_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=2 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field FTE
function fte_k8_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=1 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field FTE
function fte_all_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN schoolbenchmarks ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all big6 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_big6_nozero_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=4 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_k12_nozero_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=3 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_smallk12_nozero_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=2 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_k8_nozero_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE users.nSizeID=1 AND stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_all_nozero_previous($field)
{
global $schoolbenchmark;
global $previousBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN schoolbenchmarks ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."' WHERE stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
/******************************************************
Previous minus one year functions
Functions for the previous year, same as above but for the year before
*****************************************************/
//get average of all big6 schools for specified db field
function get_big6_previous_minusone($field)
{
global $schoolbenchmark_previous_minusone;
global $arrBenchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=4 AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field
function get_k12_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=3 AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field
function get_smallk12_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=2 AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field
function get_k8_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks LEFT JOIN users ON users.id=schoolbenchmarks.nSchoolsID WHERE users.nSizeID=1 AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field
function get_all_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM schoolbenchmarks WHERE schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all big6 schools for specified db field FTE
function fte_big6_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=4 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field FTE
function fte_k12_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=3 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field FTE
function fte_smallk12_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=2 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field FTE
function fte_k8_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=1 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field FTE
function fte_all_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN schoolbenchmarks ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all big6 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_big6_nozero_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=4 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-12 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_k12_nozero_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=3 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all small k-12 schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_smallk12_nozero_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=2 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all k-8 only schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_k8_nozero_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN users ON users.id=stafffte.nSchoolsID LEFT JOIN schoolbenchmarks ON users.id=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE users.nSizeID=1 AND stafffte.nBenchmarksID='".$benchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
//get average of all schools for specified db field FTE WITH NO ZEROS INCLUDED IN AVERAGE
function fte_all_nozero_previous_minusone($field)
{
global $schoolbenchmark;
global $benchmark;
$value=mirage_dbdo("SELECT AVG(".$field.") AS ".$field." FROM stafffte LEFT JOIN schoolbenchmarks ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID AND schoolbenchmarks.nBenchmarksID='".$benchmark['id']."' WHERE stafffte.nBenchmarksID='".$previousBenchmark['id']."' AND schoolbenchmarks.bSubmitted='1' AND ".$field."!='0' AND schoolbenchmarks.bExcludeFromAverages!='1'","SELECT");
return $value[$field];
}
function get_total_schools()
{
$schools = mirage_dbdo("
SELECT
COUNT(*)
FROM
schoolbenchmarks
RIGHT JOIN
users ON schoolbenchmarks.nSchoolsID=users.id
WHERE
schoolbenchmarks.nBenchmarksID='".$_GET['nBenchmarksID']."'
AND
users.nDistrictNumber!=0
AND
users.nUserType = 2
AND
users.bDeleted='0'
","SELECT");
return $schools["COUNT(*)"];
}
function get_large_schools()
{
$schools = mirage_dbdo("SELECT
COUNT(*)
FROM
schoolbenchmarks
RIGHT JOIN
users ON schoolbenchmarks.nSchoolsID=users.id
WHERE
schoolbenchmarks.nBenchmarksID='".$_GET['nBenchmarksID']."'
AND
users.nDistrictNumber!=0
AND
users.nUserType = 2
AND
users.bDeleted='0' AND nSizeID=4", "SELECT");
return $schools["COUNT(*)"];
}
function get_medium_schools()
{
$schools = mirage_dbdo("SELECT
COUNT(*)
FROM
schoolbenchmarks
RIGHT JOIN
users ON schoolbenchmarks.nSchoolsID=users.id
WHERE
schoolbenchmarks.nBenchmarksID='".$_GET['nBenchmarksID']."'
AND
users.nDistrictNumber!=0
AND
users.nUserType = 2
AND
users.bDeleted='0' AND nSizeID=3", "SELECT");
return $schools["COUNT(*)"];
}
function get_small_schools()
{
$schools = mirage_dbdo("SELECT
COUNT(*)
FROM
schoolbenchmarks
RIGHT JOIN
users ON schoolbenchmarks.nSchoolsID=users.id
WHERE
schoolbenchmarks.nBenchmarksID='".$_GET['nBenchmarksID']."'
AND
users.nDistrictNumber!=0
AND
users.nUserType = 2
AND
users.bDeleted='0' AND nSizeID=2", "SELECT");
return $schools["COUNT(*)"];
}
function get_k8_schools()
{
$schools = mirage_dbdo("SELECT
COUNT(*)
FROM
schoolbenchmarks
RIGHT JOIN
users ON schoolbenchmarks.nSchoolsID=users.id
WHERE
schoolbenchmarks.nBenchmarksID='".$_GET['nBenchmarksID']."'
AND
users.nDistrictNumber!=0
AND
users.nUserType = 2
AND
users.bDeleted='0' AND nSizeID=1", "SELECT");
return $schools["COUNT(*)"];
}
//get BEST student ratio for all schools
function best_student_ratio_currentyear()
{
global $arrBenchmark;
$value=mirage_dbdo("
SELECT
schoolbenchmarks.nSchoolsID,
(nKindergartenRegular+
nGrade1Regular+
nGrade2Regular+
nGrade3Regular+
nGrade4Regular+
nGrade5Regular+
nGrade6Regular+
nGrade7Regular+
nGrade8Regular+
nGrade9Regular+
nGrade10Regular+
nGrade11Regular+
nGrade12Regular+
nKindergartenInternational+
nGrade1International+
nGrade2International+
nGrade3International+
nGrade4International+
nGrade5International+
nGrade6International+
nGrade7International+
nGrade8International+
nGrade9International+
nGrade10International+
nGrade11International+
nGrade12International+
nKindergartenFirstNations+
nGrade1FirstNations+
nGrade2FirstNations+
nGrade3FirstNations+
nGrade4FirstNations+
nGrade5FirstNations+
nGrade6FirstNations+
nGrade7FirstNations+
nGrade8FirstNations+
nGrade9FirstNations+
nGrade10FirstNations+
nGrade11FirstNations+ nGrade12FirstNations)/(nElementaryTeacher+nMiddleTeacher+nHighTeacher+nElementaryAssistant+nMiddleAssistant+nHighAssistant+nElementaryPrincipals+nMiddlePrincipals+nHighPrincipals+nElementaryAssistantPrincipals+nMiddleAssistantPrincipals+nHighAssistantPrincipals+nElementaryCurriculum+nMiddleCurriculum+nHighCurriculum+nElementaryLibrarianTeaching+nMiddleLibrarianTeaching+nHighLibrarianTeaching+nElementaryLibrarian+nMiddleLibrarian+nHighLibrarian+nElementaryCounsellors+nMiddleCounsellors+nHighCounsellors+nElementaryInternational+nMiddleInternational+nHighInternational+nElementaryFirstNations+nMiddleFirstNations+nHighFirstNations)
AS ratio
FROM
schoolbenchmarks
LEFT JOIN
stafffte ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID
WHERE
schoolbenchmarks.nBenchmarksID='".$arrBenchmark['id']."'
AND
stafffte.nBenchmarksID='".$arrBenchmark['id']."'
ORDER BY ratio DESC
LIMIT 1
","SELECT");
return $value['ratio'];
}
function best_student_ratio_previousyear()
{
global $previousBenchmark;
$value=mirage_dbdo("
SELECT
schoolbenchmarks.nSchoolsID,
(nKindergartenRegular+
nGrade1Regular+
nGrade2Regular+
nGrade3Regular+
nGrade4Regular+
nGrade5Regular+
nGrade6Regular+
nGrade7Regular+
nGrade8Regular+
nGrade9Regular+
nGrade10Regular+
nGrade11Regular+
nGrade12Regular+
nKindergartenInternational+
nGrade1International+
nGrade2International+
nGrade3International+
nGrade4International+
nGrade5International+
nGrade6International+
nGrade7International+
nGrade8International+
nGrade9International+
nGrade10International+
nGrade11International+
nGrade12International+
nKindergartenFirstNations+
nGrade1FirstNations+
nGrade2FirstNations+
nGrade3FirstNations+
nGrade4FirstNations+
nGrade5FirstNations+
nGrade6FirstNations+
nGrade7FirstNations+
nGrade8FirstNations+
nGrade9FirstNations+
nGrade10FirstNations+
nGrade11FirstNations+ nGrade12FirstNations)/(nElementaryTeacher+nMiddleTeacher+nHighTeacher+nElementaryAssistant+nMiddleAssistant+nHighAssistant+nElementaryPrincipals+nMiddlePrincipals+nHighPrincipals+nElementaryAssistantPrincipals+nMiddleAssistantPrincipals+nHighAssistantPrincipals+nElementaryCurriculum+nMiddleCurriculum+nHighCurriculum+nElementaryLibrarianTeaching+nMiddleLibrarianTeaching+nHighLibrarianTeaching+nElementaryLibrarian+nMiddleLibrarian+nHighLibrarian+nElementaryCounsellors+nMiddleCounsellors+nHighCounsellors+nElementaryInternational+nMiddleInternational+nHighInternational+nElementaryFirstNations+nMiddleFirstNations+nHighFirstNations)
AS ratio
FROM
schoolbenchmarks
LEFT JOIN
stafffte ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID
WHERE
schoolbenchmarks.nBenchmarksID='".$previousBenchmark['id']."'
AND
stafffte.nBenchmarksID='".$previousBenchmark['id']."'
ORDER BY ratio DESC
LIMIT 1
","SELECT");
return $value['ratio'];
}
function best_student_ratio_previousyear_minusone()
{
global $previous_minusone;
$value=mirage_dbdo("
SELECT
schoolbenchmarks.nSchoolsID,
(nKindergartenRegular+
nGrade1Regular+
nGrade2Regular+
nGrade3Regular+
nGrade4Regular+
nGrade5Regular+
nGrade6Regular+
nGrade7Regular+
nGrade8Regular+
nGrade9Regular+
nGrade10Regular+
nGrade11Regular+
nGrade12Regular+
nKindergartenInternational+
nGrade1International+
nGrade2International+
nGrade3International+
nGrade4International+
nGrade5International+
nGrade6International+
nGrade7International+
nGrade8International+
nGrade9International+
nGrade10International+
nGrade11International+
nGrade12International+
nKindergartenFirstNations+
nGrade1FirstNations+
nGrade2FirstNations+
nGrade3FirstNations+
nGrade4FirstNations+
nGrade5FirstNations+
nGrade6FirstNations+
nGrade7FirstNations+
nGrade8FirstNations+
nGrade9FirstNations+
nGrade10FirstNations+
nGrade11FirstNations+ nGrade12FirstNations)/(nElementaryTeacher+nMiddleTeacher+nHighTeacher+nElementaryAssistant+nMiddleAssistant+nHighAssistant+nElementaryPrincipals+nMiddlePrincipals+nHighPrincipals+nElementaryAssistantPrincipals+nMiddleAssistantPrincipals+nHighAssistantPrincipals+nElementaryCurriculum+nMiddleCurriculum+nHighCurriculum+nElementaryLibrarianTeaching+nMiddleLibrarianTeaching+nHighLibrarianTeaching+nElementaryLibrarian+nMiddleLibrarian+nHighLibrarian+nElementaryCounsellors+nMiddleCounsellors+nHighCounsellors+nElementaryInternational+nMiddleInternational+nHighInternational+nElementaryFirstNations+nMiddleFirstNations+nHighFirstNations)
AS ratio
FROM
schoolbenchmarks
LEFT JOIN
stafffte ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID
WHERE
schoolbenchmarks.nBenchmarksID='".$previous_minusone['id']."'
AND
stafffte.nBenchmarksID='".$previous_minusone['id']."'
ORDER BY ratio DESC
LIMIT 1
","SELECT");
return $value['ratio'];
}
function best_student_ratio_previousyear_minustwo()
{
global $previous_minustwo;
$value=mirage_dbdo("
SELECT
schoolbenchmarks.nSchoolsID,
(nKindergartenRegular+
nGrade1Regular+
nGrade2Regular+
nGrade3Regular+
nGrade4Regular+
nGrade5Regular+
nGrade6Regular+
nGrade7Regular+
nGrade8Regular+
nGrade9Regular+
nGrade10Regular+
nGrade11Regular+
nGrade12Regular+
nKindergartenInternational+
nGrade1International+
nGrade2International+
nGrade3International+
nGrade4International+
nGrade5International+
nGrade6International+
nGrade7International+
nGrade8International+
nGrade9International+
nGrade10International+
nGrade11International+
nGrade12International+
nKindergartenFirstNations+
nGrade1FirstNations+
nGrade2FirstNations+
nGrade3FirstNations+
nGrade4FirstNations+
nGrade5FirstNations+
nGrade6FirstNations+
nGrade7FirstNations+
nGrade8FirstNations+
nGrade9FirstNations+
nGrade10FirstNations+
nGrade11FirstNations+ nGrade12FirstNations)/(nElementaryTeacher+nMiddleTeacher+nHighTeacher+nElementaryAssistant+nMiddleAssistant+nHighAssistant+nElementaryPrincipals+nMiddlePrincipals+nHighPrincipals+nElementaryAssistantPrincipals+nMiddleAssistantPrincipals+nHighAssistantPrincipals+nElementaryCurriculum+nMiddleCurriculum+nHighCurriculum+nElementaryLibrarianTeaching+nMiddleLibrarianTeaching+nHighLibrarianTeaching+nElementaryLibrarian+nMiddleLibrarian+nHighLibrarian+nElementaryCounsellors+nMiddleCounsellors+nHighCounsellors+nElementaryInternational+nMiddleInternational+nHighInternational+nElementaryFirstNations+nMiddleFirstNations+nHighFirstNations)
AS ratio
FROM
schoolbenchmarks
LEFT JOIN
stafffte ON stafffte.nSchoolsID=schoolbenchmarks.nSchoolsID
WHERE
schoolbenchmarks.nBenchmarksID='".$previous_minustwo['id']."'
AND
stafffte.nBenchmarksID='".$previous_minustwo['id']."'
ORDER BY ratio DESC
LIMIT 1
","SELECT");
return $value['ratio'];
}
?>
Society of Christian Schools in BC Network - Login