include ("session.php"); include("jadmin/lib/config.php"); include("jadmin/lib/connect.php"); include("function.php"); if($_GET['key']=="activity"){ $txt_topmemu=2; $txt_bg="inner-banner4"; $txt_nav="กิจกรรม"; $txt_img="sub-head-gallery-1"; $txt_top_leftmemu=1; }else if($_GET['key']=="location"){ $txt_topmemu=2; $txt_bg="inner-banner4"; $txt_nav="สถานที่"; $txt_img="sub-head-gallery-2"; $txt_top_leftmemu=2; }else if($_GET['key']=="portfolio"){ $txt_topmemu=2; $txt_bg="inner-banner4"; $txt_nav="ผลงานนักเรียน"; $txt_img="sub-head-gallery-3"; $txt_top_leftmemu=3; } $masterkey=$_GET['key']; include("jadmin/mod_photo/config.php"); if($groupID<=0){ $sql_count= "SELECT ".$mod_tb_root_group."_id FROM ".$mod_tb_root_group." WHERE ".$mod_tb_root_group."_masterkey='".$masterkey."' AND ".$mod_tb_root_group."_status='Enable' ORDER BY ".$mod_tb_root_group."_order DESC limit 0,1 "; $query_count=mysql_query($sql_count); $row_count=mysql_fetch_array($query_count); $groupID=$row_count[0]; } ## Default Value ############################################ $SystemModule_defaultPageSize =6; $SystemModule_defaultPageShow = 1; $SystemModule_MaxPage = 5; //$SystemModule_ReduceRange = 7; // +,- from current page show # Check to set default value ######################### if($PageSize=="") { $PageSize = $SystemModule_defaultPageSize; } if($PageShow=="") { $PageShow = $SystemModule_defaultPageShow; } $sql_photo ="SELECT ".$mod_tb_root_album."_id,".$mod_tb_root_album."_subject ,".$mod_tb_root_album."_masterkey ,".$mod_tb_root_album."_title ,".$mod_tb_root_album."_credate ,".$mod_tb_root_album."_count FROM ".$mod_tb_root_album." WHERE ".$mod_tb_root_album."_masterkey='".$masterkey."' AND ".$mod_tb_root_album."_language='Thai'"; $sql_photo.=" AND ".$mod_tb_root_album."_status='Enable'"; if($groupID>=1){ $sql_photo.=" AND ".$mod_tb_root_album."_gid='".$groupID."'"; } $query_photo=mysql_query($sql_photo); $TotalRecordCount=mysql_num_rows($query_photo); # Find max page size ######################### if($TotalRecordCount>$PageSize) { $NoOfPage= ceil($TotalRecordCount/$PageSize); } else { $NoOfPage=1; } # Recover page show into range ######################### if($PageShow>$NoOfPage) { $PageShow=$NoOfPage; } # Select only paging range ######################### $RecordStart = ($PageShow-1)*$PageSize; $sql_photo.=" ORDER BY ".$mod_tb_root_album."_order DESC LIMIT $RecordStart,$PageSize"; $query_photo=mysql_query($sql_photo); $RecordCount=mysql_num_rows($query_photo); $colcount=0; $colsize=3; ?>
|
|
|