:: สหกรณ์ออมทรัพย์ครูสุรินทร์ จำกัด ::

";} if($NRow==0) { echo "ไม่มีข้อมูลกิจกรรม $chkadd

\n"; } else { echo "\n"; $round=1; while ($row = mysql_fetch_array($result)) { $No = $row["No"]; $Title = $row["Question"]; $Detail = $row["Note"]; $shortnote= $row["shortnote"]; $Date1 = trim(substr($row["Date"],0,11)); $nphoto = $row["nphoto"]; $ndata = $row["ndata"]; $ndata = $row["ndata"]; $ndata_size = $row["ndata_size"]; $pageviewdata = $row["pageview"]; $ext = strtolower(end(explode('.',$ndata))); $pageviewdata = $row["pageview"]; $pcate1 = $row["Category"]; if($pcate1=="center") { $showcate1="เจ้าหน้าที่ทั่วไป"; } elseif ($pcate1=="sapa") { $showcate1="สภา อบต. "; } elseif ($pcate1=="syota") { $showcate1="ส่วนโยธา "; } elseif ($pcate1=="splud") { $showcate1="สนง.ปลัด"; } elseif ($pcate1=="smoney") { $showcate1="ส่วนการคลัง "; } elseif ($pcate1=="sedu") { $showcate1="ส่วนการศึกษา"; } elseif($pcate1=="admin") { $showcate1="admin"; } $sql2= "select * from tb_gallery where ref_no='$No'"; $result2 = mysql_db_query($dbname,$sql2) or die(""); $NRow2= mysql_num_rows($result2); if($round%3==1) { echo " "; } if($sess_useradmin) {$chkedit="

";} if($nphoto) { echo" "; } else { echo" "; } if($round%3==0) { echo""; $round=0; } $round++; } echo "

$Title-$shortnote $chkedit "; if($ndata){ if($ndata_size<10001024) {$data_size1=$ndata_size/1024;$b="KB";} else if($ndata_size<10001048576) {$data_size1=$ndata_size/1048576;$b="MB";} else if($ndata_size<1000*1073741824) {$data_size1=$ndata_size/1073741824;$b="TB";} if($ext=="doc" or $ext=="docx"){$img="iconword.gif";}else if($ext=="xls" or $ext=="xlsx"){$img="iconexcel.gif";}else if($ext=="ppt" or $ext=="pptx"){$img="iconpower.gif";}else if($ext=="pdf"){$img="iconacrobat.gif";}else if($ext=="rar"){$img="iconrar.gif";}else if($ext=="apk"){$img="iconapk.png";}else if($ext=="zip"){$img="iconzip.png";}else if($ext=="jpg"){$img="iconpic.png";}else{$img="icondown.gif";} echo " [ ดาวน์โหลดไฟล์ (".number_format( $data_size1 , 2 )." $b) ] "; } if($Date1==$chk_date) { echo" "; } echo"	$Title-$shortnote $chkedit "; if($ndata){ if($ndata_size<10001024) {$data_size1=$ndata_size/1024;$b="KB";} else if($ndata_size<10001048576) {$data_size1=$ndata_size/1048576;$b="MB";} else if($ndata_size<1000*1073741824) {$data_size1=$ndata_size/1073741824;$b="TB";} if($ext=="doc" or $ext=="docx"){$img="iconword.gif";}else if($ext=="xls" or $ext=="xlsx"){$img="iconexcel.gif";}else if($ext=="ppt" or $ext=="pptx"){$img="iconpower.gif";}else if($ext=="pdf"){$img="iconacrobat.gif";}else if($ext=="rar"){$img="iconrar.gif";}else if($ext=="apk"){$img="iconapk.png";}else if($ext=="zip"){$img="iconzip.png";}else if($ext=="jpg"){$img="iconpic.png";}else{$img="icondown.gif";} echo " [ ดาวน์โหลดไฟล์ (".number_format( $data_size1 , 2 )." $b) ] "; } if($Date1==$chk_date) { echo" "; } echo"

\n\n"; // table แสดงเลขหน้า echo "\n"; echo "\n"; echo "

\n"; echo "\t\n"; echo " หน้าที่ "; // วนลูปแสดงเลขหน้าทั้งหมด for($i=1 ; $i<$page ; $i++) { echo "\t$i \n"; } echo "\t$page \n"; for($i=$page+1 ; $i<=$totalpage ; $i++) { echo "\t$i \n"; } echo "

\n"; } mysql_close(); ?>