Rows($sql); $co_id = $r_c[0]['co_id']; #-------------------------------------------------------------------------- #ORTHER NEWS moi hon $sql2 = "SELECT co_id,main_name,account,at_id FROM tbl_company WHERE at_id=1 and co_id > '$co_id' ORDER BY co_id ASC LIMIT 0,5"; $r2 = $db->Rows($sql2); #ORTHER NEWS cu hon $sql3 = "SELECT co_id,main_name,account,at_id FROM tbl_company WHERE at_id=1 and co_id < '$co_id' ORDER BY co_id DESC LIMIT 0,5"; $r3 = $db->Rows($sql3); #-------------------------------------------------------------------------- $smarty->assign('r',$r); $smarty->assign('r_c',$r_c); $smarty->assign('r2',$r2); $smarty->assign('r3',$r3); $smarty->assign('company',$company); #-------------------------------------------------------------------------- $smarty->display($template_root.'about_company_detail.tpl'); ?>