"; } ?>

"; echo ""; include('condb.php'); echo "  บุคลากร คณะเกษตร กำแพงแสน"; $SelGroup="select * from tgroupskill where Group_Skill_ID='$Group_Skill_ID' "; $dbGroup=mysql_db_query($dbname,$SelGroup) or die (ไม่สามารถติดต่อฐานข้อมูลได้); $rsGroup = mysql_fetch_array($dbGroup); $Group_Skill_Name = $rsGroup['Group_Skill_Name']; ?> "; }else{ if ($Page >= 1){} else{ $Page = 1;} $Gopage=$HTTP_GET_VARS["Page"]; if ($Gopage==""){ $Gopage=1; } $Pagesize=$HTTP_GET_VARS["Pagesize"]; $Pagesize=20; $Maxcount=ceil($num1/$Pagesize); $Gopage=(($Gopage-1)*$Pagesize)+$Recs; $Recs=1; $Checkpage= ($Gopage/$Pagesize)+1; If ($Checkpage==$Maxcount) { $Newsize=$num1 % $Pagesize; if($Newsize==0){ $Newsize=$num1;} $Pagesize=$Newsize; } echo " - พบจำนวน ".$num1." รายการ - "; ?>""){ $SelP2 ="select skill.*, identity.*,personal.* from personal inner join identity on identity.Per_ID=personal.Per_ID inner join skill on skill.Per_ID=personal.Per_ID where skill.Group_Skill_ID='$Group_Skill_ID' and identity.Iden_Depart='$id' and identity.Iden_Current='1' and identity.Iden_Status<='1' order by identity.Iden_Depart asc limit $Gopage,$Pagesize"; }else{ $SelP2 ="select skill.*, identity.*,personal.* from personal inner join identity on identity.Per_ID=personal.Per_ID inner join skill on skill.Per_ID=personal.Per_ID where skill.Group_Skill_ID='$Group_Skill_ID' and identity.Iden_Current='1' and identity.Iden_Status<='1' order by identity.Iden_Depart asc limit $Gopage,$Pagesize"; } $dbSelP2= mysql_query($SelP2); While ($Recs <= $Pagesize) { $Number = $Gopage+$Recs; $rsP1 = mysql_fetch_array($dbSelP2); //$rsP1 = mysql_fetch_array($dbSelP1); $Per_ID = $rsP1['Per_ID']; $Per_Prefix = $rsP1['Per_Prefix']; $Per_TName = $rsP1['Per_TName']; $Per_FName = $rsP1['Per_FName']; $Per_LName = $rsP1['Per_LName']; $Iden_Position = $rsP1['Iden_Position']; $Iden_Type = $rsP1['Iden_Type']; $Iden_Depart = $rsP1['Iden_Depart']; $Skill_Name = $rsP1['Skill_Name']; $sqlD = "select * from tdepartment where id='$Iden_Depart' "; $dbsqlD=mysql_db_query($dbname,$sqlD) or die (ไม่สามารถติดต่อฐานข้อมูลได้); $rsD=mysql_fetch_array($dbsqlD); $name=$rsD['name']; $edu="select * from education where Per_ID='$Per_ID' and tedu_id=30 "; $dbedu=mysql_db_query($dbname,$edu); $nedu=mysql_num_rows($dbedu); if($nedu>0){ if($Per_Prefix<>""){ $Per_TName=$Per_Prefix."ดร." ; }else{ $Per_TName="ดร."; } }else{ if($Per_Prefix<>""){ $Per_TName=$Per_Prefix ; }else{ $Per_TName=$Per_TName; } } If ($bg=="#EFEFEF"){ $bg="#F9F9F9"; }Else{ $bg="#EFEFEF"; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $Recs++; } ?> ""){ $SelDep="select * from tdepartment where id='$dep' "; $dbDep=mysql_db_query($dbname, $SelDep); $numDep=mysql_num_rows($dbDep); $rsDep=mysql_fetch_array($dbDep); $id=$rsDep['id']; $name=$rsDep['name']; echo "แสดงข้อมูลบุคลากร$name กลุ่มสาขาเชี่ยวชาญด้าน$Group_Skill_Name"; }else{ echo "แสดงข้อมูลบุคลากรคณะเกษตร กำแพงแสน กลุ่มสาขาเชี่ยวชาญด้าน$Group_Skill_Name"; } ?> ""){ $SelP1 ="select skill.*, identity.*,personal.* from personal inner join identity on identity.Per_ID=personal.Per_ID inner join skill on skill.Per_ID=personal.Per_ID where skill.Group_Skill_ID='$Group_Skill_ID' and identity.Iden_Depart='$id' and identity.Iden_Current='1' and identity.Iden_Status<='1' order by identity.Iden_Depart asc"; }else{ $SelP1 ="select skill.*, identity.*,personal.* from personal inner join identity on identity.Per_ID=personal.Per_ID inner join skill on skill.Per_ID=personal.Per_ID where skill.Group_Skill_ID='$Group_Skill_ID' and identity.Iden_Current='1' and identity.Iden_Status<='1' order by identity.Iden_Depart asc"; } $dbSelP1=mysql_db_query($dbname,$SelP1) or die (ไม่สามารถติดต่อฐานข้อมูลได้); $num1=mysql_num_rows($dbSelP1); if ($num1=='0'){ echo " ยังไม่ได้ใส่ข้อมูล           ชื่อสาขาเชี่ยวชาญ ชื่อ-นามสกุล หน่วยงาน   "; echo "$Number.  "; echo " "; echo "$Skill_Name"; echo " "; //echo ""; echo "  $Per_TName $Per_FName   $Per_LName"; //echo ""; echo " "; echo "  "; echo $name; echo ""; echo " Page ".$Checkpage." / " .$Maxcount .""; //echo " "; If ($Checkpage>1){ echo "[ Previous ] "; } If ($Checkpage<$Maxcount) { echo " [ Next ] "; } echo " [ "; $Pad=""; $Scriptname=${"Script_Name"}; for ($N=1; $N<=$Maxcount; $N=$N+1){ if ($N>=10){ $Pad=""; } $Ref="".$Pad.$N.""; echo " ".$Ref." "; } echo " ] "; }// num_row == 0 //mysql_close($conn); ?>