$sql9 = "SELECT * FROM tb_sector order by sector_id";
//echo $sql9." ";
$results9 = $mysqli->query($sql9);
$count9=$results9->num_rows;
while ($row9 = $results9->fetch_assoc()) {
$sector_name = $row9['sector_name'];
$sector_id = $row9['sector_id'];
$sql91 = "SELECT * FROM host_parties_meet
where
year_id='$system_year' and
level_host_id_meet='1' and
sector_id_meet='$sector_id'
order by province_id_meet,college_id,ty_id";
//echo $sql9." ";
$results91 = $mysqli->query($sql91);
$count91=$results91->num_rows;
?>
echo $count91;?>
echo $sector_name;?>
while ($row91 = $results91->fetch_assoc()) {
$province_id_meet = $row91['province_id_meet'];
$college_id = $row91['college_id'];
$position_id = $row91['position_id'];
$pin_id = $row91['pin_id'];
$year_id_regis = $row91['year_id_regis'];
$ty_id = $row91['ty_id'];
$province_name ="";
$college_name ="";
$name = "";
$lname = "";
$position_name ="";
$sql92 = "SELECT * FROM provinces
where
PROVINCE_CODE='$province_id_meet'";
//echo $sql9." ";
$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 host_parties_orga
where
p_pin_id='$pin_id'";
//echo $sql9." ";
$results92 = $mysqli->query($sql92);
$count92=$results92->num_rows;
if($count92==0){
$sql93 = "DELETE FROM host_parties_meet
where
pin_id like '$pin_id' ";
//echo $sql9." ";
$results93 = $mysqli->query($sql93);
$name ="--ลบ--";
}else{
$row92 = $results92->fetch_assoc();
$name = $row92['prename'].$row92['fname'];
$lname = $row92['lname'];
}
$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;
}
?>