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']; if($ty_id==1){ $position_name=$position_name." ".$year_id_regis; } $aa++; ?>