fetch_assoc()) { $name = $row9['prename'].$row9['fname']; $lname = $row9['lname']; $college_id = $row9['pcollege_id']; $position_id = $row9['position_id']; $pin_id = $row9['p_pin_id']; $province_id = $row9['province_id']; $sector_id = $row9['sector_id']; $sql92 = "SELECT * FROM provinces where PROVINCE_CODE like '$province_id'"; //echo $sql92."
"; $results92 = $mysqli->query($sql92); $count92=$results92->num_rows; $row92 = $results92->fetch_assoc(); $province_name = $row92['PROVINCE_NAME']; $sql92 = "SELECT * FROM college where college_id='$college_id'"; //echo $sql9."
"; $results92 = $mysqli->query($sql92); $count92=$results92->num_rows; $row92 = $results92->fetch_assoc(); $college_name = $row92['college_name']; $sql92 = "SELECT * FROM position where position_id='$position_id'"; //echo $sql9."
"; $results92 = $mysqli->query($sql92); $count92=$results92->num_rows; $row92 = $results92->fetch_assoc(); $position_name = $row92['position_name']; $sql93 = "SELECT * FROM host_parties_meet where year_id='$system_year' and pin_id='$pin_id' and level_host_id_meet='3' "; //echo $sql9."
"; $results93 = $mysqli->query($sql93); $count_meet3=$results93->num_rows; $sql93 = "SELECT * FROM host_parties_meet where year_id='$system_year' and pin_id='$pin_id' and level_host_id_meet='2' "; //echo $sql9."
"; $results93 = $mysqli->query($sql93); $count_meet2=$results93->num_rows; $sql93 = "SELECT * FROM host_parties_meet where year_id='$system_year' and pin_id='$pin_id' and level_host_id_meet='1' "; //echo $sql9."
"; $results93 = $mysqli->query($sql93); $count_meet1=$results93->num_rows; if($ty_id==1){ $position_name=$position_name." ".$year_id_regis; } $aa++; ?>

ลำดับ	จังหวัด	วิทยาลัย	ชื่อ	สกุล	ตำแหน่ง	จังหวัด	ภาค	ชาติ