ฝ่ายบริหาร
หัวหน้างาน
$sql2 = "SELECT * FROM m_secretary where secretary_level=1 and secretary_level2=2 and secretary_status=1 ";
$rs2 = $conn->Execute($sql2);
while (!$rs2->EOF) {
$secretary_id =$rs2->fields["secretary_id"];
$secretary_level =$rs2->fields["secretary_level"];
$secretary_level_name_th = getData("secretary_level_name_th","m_secretary_level"," where secretary_level_id=".$secretary_level);
$secretary_pic =$rs2->fields["secretary_pic"];
$secretary_title_th =$rs2->fields["secretary_title_th"];
$secretary_title_en = $rs2->fields["secretary_title_en"];
$secretary_name_th = $rs2->fields["secretary_name_th"];
$secretary_name_en = $rs2->fields["secretary_name_en"];
$secretary_desc_th = $rs2->fields["secretary_desc_th"];
$secretary_desc_en = $rs2->fields["secretary_desc_en"];
$secretary_social_facebook = $rs2->fields["secretary_social_facebook"];
$secretary_social_twitter = $rs2->fields["secretary_social_twitter"];
$secretary_social_google = $rs2->fields["secretary_social_google"];
$secretary_social_email = $rs2->fields["secretary_social_email"];
if($secretary_pic!=""){
$secretary_pic_p = $path1.$secretary_pic;
}
?>
$i2++;
if(($i2%3)==0){
echo "";
}
$rs2->MoveNext();
}
?>
$path1 = "files/secretary/";
$sql1 = "SELECT * FROM m_secretary where secretary_level=2 and secretary_level2=1 secretary_status=1 ";
$rs1 = $conn->Execute($sql1);
$secretary_id =$rs1->fields["secretary_id"];
$secretary_level =$rs1->fields["secretary_level"];
$secretary_level_name_th = getData("secretary_level_name_th","m_secretary_level"," where secretary_level_id=".$secretary_level);
$secretary_pic =$rs1->fields["secretary_pic"];
$secretary_title_th =$rs1->fields["secretary_title_th"];
$secretary_title_en = $rs1->fields["secretary_title_en"];
$secretary_name_th = $rs1->fields["secretary_name_th"];
$secretary_name_en = $rs1->fields["secretary_name_en"];
$secretary_desc_th = $rs1->fields["secretary_desc_th"];
$secretary_desc_en = $rs1->fields["secretary_desc_en"];
$secretary_social_facebook = $rs1->fields["secretary_social_facebook"];
$secretary_social_twitter = $rs1->fields["secretary_social_twitter"];
$secretary_social_google = $rs1->fields["secretary_social_google"];
$secretary_social_email = $rs1->fields["secretary_social_email"];
if($secretary_pic!=""){
$secretary_pic_p = $path1.$secretary_pic;
}
?>
พนักงาน
$sql2 = "SELECT * FROM m_secretary where secretary_level=1 and secretary_level2=3 and secretary_status=1 ";
$rs2 = $conn->Execute($sql2);
while (!$rs2->EOF) {
$secretary_id =$rs2->fields["secretary_id"];
$secretary_level =$rs2->fields["secretary_level"];
$secretary_level_name_th = getData("secretary_level_name_th","m_secretary_level"," where secretary_level_id=".$secretary_level);
$secretary_pic =$rs2->fields["secretary_pic"];
$secretary_title_th =$rs2->fields["secretary_title_th"];
$secretary_title_en = $rs2->fields["secretary_title_en"];
$secretary_name_th = $rs2->fields["secretary_name_th"];
$secretary_name_en = $rs2->fields["secretary_name_en"];
$secretary_desc_th = $rs2->fields["secretary_desc_th"];
$secretary_desc_en = $rs2->fields["secretary_desc_en"];
$secretary_social_facebook = $rs2->fields["secretary_social_facebook"];
$secretary_social_twitter = $rs2->fields["secretary_social_twitter"];
$secretary_social_google = $rs2->fields["secretary_social_google"];
$secretary_social_email = $rs2->fields["secretary_social_email"];
if($secretary_pic!=""){
$secretary_pic_p = $path1.$secretary_pic;
}
?>
$i2++;
if(($i2%3)==0){
echo "";
}
$rs2->MoveNext();
}
?>
ฝ่ายวิชาการ
หัวหน้างาน
$sql2 = "SELECT * FROM m_secretary where secretary_level=2 and secretary_level2=2 and secretary_status=1 ";
$rs2 = $conn->Execute($sql2);
while (!$rs2->EOF) {
$secretary_id =$rs2->fields["secretary_id"];
$secretary_level =$rs2->fields["secretary_level"];
$secretary_level_name_th = getData("secretary_level_name_th","m_secretary_level"," where secretary_level_id=".$secretary_level);
$secretary_pic =$rs2->fields["secretary_pic"];
$secretary_title_th =$rs2->fields["secretary_title_th"];
$secretary_title_en = $rs2->fields["secretary_title_en"];
$secretary_name_th = $rs2->fields["secretary_name_th"];
$secretary_name_en = $rs2->fields["secretary_name_en"];
$secretary_desc_th = $rs2->fields["secretary_desc_th"];
$secretary_desc_en = $rs2->fields["secretary_desc_en"];
$secretary_social_facebook = $rs2->fields["secretary_social_facebook"];
$secretary_social_twitter = $rs2->fields["secretary_social_twitter"];
$secretary_social_google = $rs2->fields["secretary_social_google"];
$secretary_social_email = $rs2->fields["secretary_social_email"];
if($secretary_pic!=""){
$secretary_pic_p = $path1.$secretary_pic;
}
?>
$i2++;
if(($i2%3)==0){
echo "";
}
$rs2->MoveNext();
}
?>
พนักงาน
$sql2 = "SELECT * FROM m_secretary where secretary_level=2 and secretary_level2=3 and secretary_status=1 ";
$rs2 = $conn->Execute($sql2);
while (!$rs2->EOF) {
$secretary_id =$rs2->fields["secretary_id"];
$secretary_level =$rs2->fields["secretary_level"];
$secretary_level_name_th = getData("secretary_level_name_th","m_secretary_level"," where secretary_level_id=".$secretary_level);
$secretary_pic =$rs2->fields["secretary_pic"];
$secretary_title_th =$rs2->fields["secretary_title_th"];
$secretary_title_en = $rs2->fields["secretary_title_en"];
$secretary_name_th = $rs2->fields["secretary_name_th"];
$secretary_name_en = $rs2->fields["secretary_name_en"];
$secretary_desc_th = $rs2->fields["secretary_desc_th"];
$secretary_desc_en = $rs2->fields["secretary_desc_en"];
$secretary_social_facebook = $rs2->fields["secretary_social_facebook"];
$secretary_social_twitter = $rs2->fields["secretary_social_twitter"];
$secretary_social_google = $rs2->fields["secretary_social_google"];
$secretary_social_email = $rs2->fields["secretary_social_email"];
if($secretary_pic!=""){
$secretary_pic_p = $path1.$secretary_pic;
}
?>
$i2++;
if(($i2%3)==0){
echo "";
}
$rs2->MoveNext();
}
?>
