Home > āļāđāļēāļ§āļāļĢāļ°āļāļēāļŠāļąāļĄāļāļąāļāļāđ 
 
        
         
$strSql="select * from tbl_news  WHERE BIT_ENABLE='True' and  INT_NEWS_CATEGORY_ID=1 and  (YEAR(DTE_NEWS_DATE)='2013' or YEAR(DTE_NEWS_DATE)='2013') order by DTE_NEWS_DATE DESC,INT_NEWS_ID DESC";
$result = mysql_query($strSql);
$num=mysql_num_rows($result);
$i = 0;
if($num>0){
$row = mysql_fetch_array($result);
$intTotalRow = $num;
$PageSize = $intMaxRow;
if ($intPage != "all") {
$sql_limit = ( $intPage == 1) ? 0 : ($intPage - 1) * $PageSize ;
$sql_limit = " LIMIT " . $sql_limit . ", " . $PageSize . " "; 
}
if ($intPage == "all") {
$intPage = 1;
$intMaxRow = $num;
$bitSelectAll = true;
}else{
$bitSelectAll = false;
}
$intTotalPage = ceil($num/$PageSize);
$c = 0;
$rec = 0;
$i = (( $intPage - 1 ) * $intMaxRow )+1;
$strSql.= $sql_limit;
$result=mysql_query($strSql);
while($row = mysql_fetch_array($result)) {
?>  
        
      
       }?>
       
if (($num > $intMaxRow) || ($bitSelectAll == true)){
?>  
       
if($intTotalPage == ""){
	$intTotalPage = 1;
}
$strUrl = "news-pr.php?lan=".$_GET["lan"];
$strPage = genPageNumber($strUrl, $intPage, $intTotalPage, $intTotalRow,  $bitSelectAll , $intPagePerOnce);
echo $strPage;
?>
       
}
?>
 
}else{?>
Coming Soon!
 }?>