<?php


	$sql_get_app=mysqli_query($conn_1, "select * FROM hostel_students WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													//$school_id=$row['school_id'];
													//$cart_id=$row['cart_id'];
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													//$school_applied_for=$row['school_applied_for'];
													//$department_applied_for=$row['department_applied_for'];
													//$programme_applied_for=$row['programme_applied_for'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
												//	$mode_of_entry=$row['mode_of_entry'];
													//$jamb_number=$row['jamb_number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													//$last_name=$row['last_name'];
													$phone_no=$row['phone_no'];
													//$qualification=$row['highest_qualification'];
													//$institution_obtained=$row['institution_obtained'];
													//$pre_year_of_graduation=$row['pre_year_of_graduation'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													//$award_in_view=$row['award_in_view'];
													//$entry_year=$row['entry_year'];
													//$cart_id=$row['cart_id'];
													//$mode_of_entry=$row['mode_of_entry'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
												//	$pdf_file=$row['pdf_file'];
													$level=$row['level'];
												///	$activities=$row['activities'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													//$guardian_email=$row['guardian_email'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
													//$sponsorship_type=$row['sponsorship_type'];
												//	$sponsorship_name=$row['sponsorship_name'];
													//$sponsorship_address=$row['sponsorship_address'];
													//$admission_batch=$row['admission_batch'];
													//$admission_serial_no=$row['admission_serial_no'];
													//$date_admitted=$row['date_admitted'];
												//	$hostel_eligibility=$row['hostel_eligibility'];
												//	$hostel_allocation=$row['hostel_allocation'];
													//$school1=$row['school1'];
													//$cert1=$row['cert1'];
													//$start_year1=$row['start_year1'];
													//$end_year1=$row['end_year1'];
													//$result1=$row['result1'];
													//$school2=$row['school2'];
													//$cert2=$row['cert2'];
													//$start_year2=$row['start_year2'];
													//$end_year2=$row['end_year2'];
													//$result2=$row['result2'];
													//$school3=$row['school3'];
													//$cert3=$row['cert3'];
													//$start_year3=$row['start_year3'];
													//$end_year3=$row['end_year3'];
													//$result3=$row['result3'];
												}
											}
									}



?>
