0){ $Rs = mysql_fetch_array($result); $intUpdate = $Rs["intDateDiff"]; $intNewsHilightID = $Rs["INT_NEWS_ID"]; $strNewsSubject = $Rs["STR_NEWS_SUBJECT"]; if (strlen($strNewsSubject)>120){ $strNewsSubject = substr($strNewsSubject,0,120).'...'; } //$strNewsDetail = genContentMore($Rs["STR_NEWS_DETAIL"],strlen($Rs["STR_NEWS_DETAIL"])); //$strNewsDetail = genContentMore($strNewsDetail,250).'...'; $strNewsDetail = $Rs["STR_NEWS_DETAIL"]; $strNewsDetail = removeHtmlTag($strNewsDetail,strlen($strNewsDetail)); if (strlen($strNewsDetail)>250){ //$strNewsDetail = genContentMore($strNewsDetail,strlen($strNewsDetail)); $strNewsDetail = substr($strNewsDetail,0,250).'...'; } $strNewsDate= RLDateFormat($Rs["DTE_NEWS_DATE"] , "md,yyyy", 2); $strNewsThumb = $Rs["STR_NEWS_IMAGE"]; if($strNewsThumb==""){ $strNewsThumb = "img/default-big.jpg"; }else{ $strNewsThumb = "../imgUpload/".$strNewsThumb; } } ?>
 
 
$intNewsHilightID order by dte_news_date desc,int_news_id desc"; $sql = "select *,DATEDIFF(DATE(NOW()),DTE_NEWS_DATE) as intDateDiff from tbl_news where int_lang = ".intLang." and bit_news_status = 1 and int_news_category_id = 1 and int_news_id <> $intNewsHilightID order by int_order asc"; $result = mysql_query($sql); $num = mysql_num_rows($result); 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") { //Rs.AbsolutePage = 1 $intPage = 1; $intMaxRow = $num; $bitSelectAll = true; }else{ //Rs.AbsolutePage = intPage $bitSelectAll = false; } $intTotalPage = ceil($num/$PageSize); $c = 0; $i = (( $intPage - 1 ) * $intMaxRow )+1; $sql.= $sql_limit; $result=mysql_query($sql); while($Rs = mysql_fetch_array($result)) { $intUpdate = $Rs["intDateDiff"]; $intNewsID = $Rs["INT_NEWS_ID"]; if (strlen($Rs["STR_NEWS_SUBJECT"])>100){ $strNewsSubject = genContentMore($Rs["STR_NEWS_SUBJECT"],100).'...'; }else{ $strNewsSubject = $Rs["STR_NEWS_SUBJECT"]; } //$strNewsDetail = genContentMore($Rs["STR_NEWS_DETAIL"],strlen($Rs["STR_NEWS_DETAIL"])); //$strNewsDetail = genContentMore($strNewsDetail,250).'...'; $strNewsDetail = $Rs["STR_NEWS_DETAIL"]; $strNewsDetail = removeHtmlTag($strNewsDetail,strlen($strNewsDetail)); if (strlen($strNewsDetail)>250){ //$strNewsDetail = genContentMore($strNewsDetail,strlen($strNewsDetail)); $strNewsDetail = substr($strNewsDetail,0,250).'...'; } $strNewsDate= RLDateFormat($Rs["DTE_NEWS_DATE"] , "md,yyyy", 2); $strNewsThumb = $Rs["STR_NEWS_THUMB"]; if($strNewsThumb==""){ $strNewsThumb = "img/default.jpg"; }else{ $strNewsThumb = "../imgUpload/".$strNewsThumb; } $c++; ?>
Coming Soon