function get_worst_manager_polls($reviewee)
{
$managers = get_managers();
$managers = join(',', $managers);
$query = mysql_query("SELECT * FROM candidate_poll WHERE Reviewee = {$reviewee} AND Reviewer IN ({$managers}) AND Ok_overall = 1 ORDER BY Score LIMIT 100 OFFSET 1");
if (!$query || mysql_num_rows($query) <= 0) {
echo mysql_error();
return false;
} else {
while ($row = mysql_fetch_assoc($query)) {
$polls[] = array('ID' => $row['ID'], 'Reviewer' => $row['Reviewer'], 'Reviewee' => $row['Reviewee'], 'Score' => $row['Score'], 'Ok_overall' => $row['Ok_overall']);
}
return $polls;
}
}
<?php
require_once '../../../util/main.php';
require_once '../../authenticate.php';
require_once '../../../view/headerForAdmin.php';
require_once '../../../model/database.php';
require_once '../../../model/location_db.php';
require_once '../../../model/employee_db.php';
$managers = get_managers();
$locations = get_locations();
?>
<div class="heading">
<div class="clearfix">
<div class="pull-left">
<h3>Employees</h3>
</div>
<div class="pull-right">
<button class="btn btn-default btn-xs" type="button" onclick="sodon_main.create('');">
<i class="glyphicon glyphicon-file text-primary"></i> Add New Employee
</button>
</div>
</div>
</div>
<div class="row">
<div class="col-xs-3">
<input id="searchParams" type="hidden" value="">
<div class="panel panel-default">
$error_notification = '';
$error_userName = '';
$error_firstName = '';
$error_lastName = '';
$error_password = '';
$error_passwordConfirm = '';
$error_title = '';
$error_location = '';
$error_phone = '';
$error_emailAddress = '';
$error_street = '';
$error_city = '';
$error_state = '';
$error_zipCode = '';
$states = array('AL', 'AK', 'AZ', 'AR', 'CA', 'CO', 'CT', 'DE', 'FL', 'GA', 'HI', 'ID', 'IL', 'IN', 'IA', 'KS', 'KY', 'LA', 'ME', 'MD', 'MA', 'MI', 'MN', 'MS', 'MO', 'MT', 'NE', 'NV', 'NH', 'NJ', 'NM', 'NY', 'NC', 'ND', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC', 'SD', 'TN', 'TX', 'UT', 'VT', 'VA', 'WA', 'WV', 'WI', 'WY');
$supervisors = get_managers();
$locations = get_locations();
$titles = array('Executive', 'Manager', 'Front desc clerk');
$employeeID = '';
$formValidation = true;
if (isset($_POST['employeeID'])) {
$employeeID = $_POST['employeeID'];
try {
$employee = array();
$employee['employeeID'] = $_POST['employeeID'];
$employee['password'] = $_POST['password'];
$employee['userName'] = $_POST['userName'];
$employee['firstName'] = $_POST['firstName'];
$employee['lastName'] = $_POST['lastName'];
$employee['street'] = $_POST['street'];
$employee['city'] = $_POST['city'];
