<!--{eval $navs = DB::fetch_all("SELECT * FROM ".DB::table('common_nav')." WHERE `available` > 0 and `navtype` = 0 and `parentid` = 0 ORDER BY `displayorder` ASC");}-->
<!--{loop $navs $nav}-->
<!--{eval $subnavs = DB::fetch_all("SELECT * FROM ".DB::table('common_nav')." WHERE `available` > 0 and `navtype` = 0 and `parentid` = $nav[id] ORDER BY `displayorder` ASC");}-->
<!--{eval $subs = DB::result(DB::query("SELECT name FROM ".DB::table('common_nav')." WHERE available > '0' and navtype = '0' and parentid = '$nav[id]'"));}-->