include("../include/header.php"); ?>
$range=3;
$pagelen=20;
$page=$_GET['page'];
if(empty($page)){$page=1;}
$sqlr = "select * from ".$table_news." where ".$table_news."_group_id ='2' and ".$table_news."_id NOT IN ('5','6','7','8','9','10','12','13','14','15','16','17','18','19','20','21','22','24','25','26','27','28','29','30','31','32') and ".$table_news."_status !='Offline' ORDER BY ".$table_news."_lastupdate DESC";
$result=$obj_db->SelectData($sqlr);
$num_rows=mysql_num_rows($result);
$num_rows_total=$num_rows;
$totalpage=ceil($num_rows/$pagelen);
$goto=($page-1)*$pagelen;
$start=$page-$range;
$end=$page+$range;
if($start<=1){
$start=1;
}
if($end>=$totalpage){
$end=$totalpage;
}
$sql = "select * from ".$table_news." where ".$table_news."_group_id ='2' and ".$table_news."_id NOT IN ('5','6','7','8','9','10','12','13','14','15','16','17','18','19','20','21','22','24','25','26','27','28','29','30','31','32') and ".$table_news."_status !='Offline' ORDER BY ".$table_news."_lastupdate DESC LIMIT $goto,$pagelen";
$resultrr=$obj_db->SelectData($sql);
$romm = mysql_num_rows($resultrr);
if($romm != 0){
while($Row_n2=mysql_fetch_array($resultrr)){
?>
• |
" target="_blank">=$Row_n2[$table_news."_subject"];?> |
|
}
} else {
echo "ไม่พบข้อมูล !!!";
}
?>
|
if($page>1){
$back=$page - 1;
echo "" ?>« echo "" ?>ก่อนหน้านี้ if($start>1){echo "...";} }?> |
For ($i=$start;$i<=$end;$i++){
if($i==$page){
?>
=$i?> |
}else{
?>
echo "" ?>=$i?> |
}
}
if($page<$totalpage){
$next=$page+1;
?>
if($end<$totalpage){echo "...";}?> echo "" ?>ถัดไป echo "" ?>» |
}
?>
|
include("../include/footer.php"); ?>