query("SELECT user_id AS 'ID', username AS 'Username', email AS 'Email', password AS 'Password', accountType AS 'Account Type', school_id AS 'School', class_id AS 'Class', active AS 'Status' FROM user_account ORDER BY user_id ASC;"); $tablesAndTheirData = array(); array_push($tablesAndTheirData, array( 'fields' => $result->fetch_fields(), 'data' => $result )); foreach($tablesAndTheirData as $table){ if($table['data']->num_rows){ ?> fetch_assoc()){ $order_num++; ?> $value){ if ($key == 'ID'){ $index = $value; } ?>

name;?>

Change query("SELECT * FROM user_role"); while ( $row = $result->fetch_assoc() ){ $typeSelected = $row['role_id'] == $value ? 'selected="true"' : ''; ?> > --- query("SELECT * FROM school"); while ( $row = $result->fetch_assoc() ){ $typeSelected = $row['school_id'] == $value ? 'selected="true"' : ''; ?> > Not Applicable --- query("SELECT * FROM school_class WHERE school_id = '$keySchool'"); while ( $row = $result->fetch_assoc() ){ $classIndex++; $typeSelected = $row['class_id'] == $value ? 'selected="true"' : ''; ?> > Not Applicable