query("SELECT school_id AS 'ID', school_name AS 'School Name', specific_sAdminCode AS 'School-Admin Code' FROM school ORDER BY school_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;?>