Rows($sql1); #-------------------------------------------------------------------------- #Tin moi hon $sql2 = "SELECT * FROM tbl_news_com WHERE news_id > '$news_id' ORDER BY news_id DESC LIMIT 0,5"; $r2 = $db->Rows($sql2); #-------------------------------------------------------------------------- #Tin cu hon $sql3 = "SELECT * FROM tbl_news_com WHERE news_id < '$news_id' ORDER BY news_id 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.'bantindoanhnghiep_detail.tpl'); ?>