include("public_inc.php");?>
connectdb();
charSetThai();
loadControl();
?>
if ($_SERVER['SCRIPT_NAME']) {
$scriptname = $_SERVER['SCRIPT_NAME'];
}
if ($_SERVER['QUERY_STRING']) {
$scriptname .= "?".$_SERVER['QUERY_STRING'];
}
$Con_GalleryPage = $FaqPage;
$currentPage = $_SERVER["PHP_SELF"];
$range = 5; // จำนวนแสดงหน้าและหลังเลขหน้าที่เลือก
$pageNum = 1;
if (isset($_GET['page'])) {
$pageNum= $_GET['page'];
}
$startRowQuery = ($pageNum-1 )* $Con_GalleryPage;
$sql = "select * from gac_tblfaq where OnlineStatus = 'Y' Order by DateRegister DESC";
$querylimit = sprintf("%s LIMIT %d, %d", $sql, $startRowQuery, $Con_GalleryPage);
$result= mysql_query($querylimit);
if (isset($_GET['totalRows'])) {
$totalRows = $_GET['totalRows'];
} else {
$allQuery= mysql_query($sql);
if($allQuery){
$totalRows = mysql_num_rows($allQuery);
}
}
$totalPages = ceil($totalRows/$Con_GalleryPage);
?>
if ($pageNum == 1) {
$start= 1;
$limit = $Con_GalleryPage;
if($limit > $totalRows){$limit = $totalRows;}
}else{
$start= ($Con_GalleryPage*$pageNum)-1;
$limit = ($Con_GalleryPage*$pageNum);
if($limit > $totalRows){$limit = $totalRows;}
}
?>
$pagegoto = ($pageNum-1) * $Con_PhotoPage; // หาหน้าที่จะกระโดดไป
$pagestart = $pageNum - $range;
$pageend = $pageNum + $range;
if ($pagestart <= 1) {
$pagestart = 1;
}
if ($pageend >= $totalPages) {
$pageend = $totalPages;
}
?>
include('include_title.php')?>
include('include_head_th.php');?>
//include('include_banner.php');?>
include('include_left_th.php');?>
 |
if($totalRows>0){
$iPhoto=1;
$iRowPhoto=1;
?>
while ($rows = mysql_fetch_array($result)){
$FaqID = convertToText(stripStr($rows["FaqID"]));
$FaqQThai = convertToText(stripStr($rows["FaqQThai"]));
$FaqAThai = convertToText(stripStr($rows["FaqAThai"]));
?>
Q |
|
A |
|
}?>
|
} else {?>
ไม่พบข้อมูล |
}@mysql_free_result($result);?>
|
if($totalPages>1){?>
if (($pageNum == $totalPages || $pagestart >1)&&(($totalPages-$range) != 1)&&($totalPages >($range+1))) { echo " 1 ..."; }?>
for($count=$pagestart;$count<=$pageend;$count++){
$num = $count;
if($num<$pageend){$sign = " | ";}else{$sign = "";}
if($pageNum == $num){
echo "$num $sign ";
}else{
echo "$num $sign ";
}
} //end count page
?>
if (($pageNum == 1 || $pageend < $totalPages)&&(($pagestart+$range) != $totalPages)&&($totalPages >($range+1))) { echo "... $totalPages";}?>
|
}?>
|
|
|
include('include_footer_th.php');?>