2"; $r1 = $db->Rows($sql1); #-------------------------------------------------------------------------- #ORTHER NEWS moi hon $sql2 = "SELECT * FROM tbl_news WHERE ne_id > '$ne_id' AND gn_id =".$r1[0]['gn_id']. " AND at_id <> 2 ORDER BY date_added LIMIT 0,5"; $r2 = $db->Rows($sql2); #ORTHER NEWS cu hon $sql3 = "SELECT * FROM tbl_news WHERE ne_id < '$ne_id' AND gn_id =".$r1[0]['gn_id']." AND at_id <> 2 ORDER BY date_added DESC LIMIT 0,5"; $r3 = $db->Rows($sql3); #BANNER $sqlBanner = "SELECT * FROM tbl_banner WHERE ba_id = 1"; $rB = $db->Rows($sqlBanner); $smarty->assign('rB',$rB); #-------------------------------------------------------------------------- $smarty->assign('r1',$r1); $smarty->assign('r2',$r2); $smarty->assign('r3',$r3); #-------------------------------------------------------------------------- $smarty->display($template_root.'news_detail.tpl'); ?>