Home > āļāđāļēāļ§āļāļīāļāļāļĢāļĢāļĄ
$strSql="select * from tbl_news WHERE BIT_ENABLE='True' and INT_NEWS_CATEGORY_ID=3 and YEAR(DTE_NEWS_DATE)='2012' 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-activities.php";
$strPage = genPageNumber($strUrl, $intPage, $intTotalPage, $intTotalRow, $bitSelectAll , $intPagePerOnce);
echo $strPage;
?>
}
?>
}else{?>
Coming Soon!
}?>