织梦怎么根据下级栏目获得顶级栏目名称？

织梦DEDECMS根据下级栏目获得顶级栏目名称

推荐学习：织梦cms

SQL语句实现

{dede:field.typeid runphp='yes'}$ID = @me; $sql = "ｓｅｌｅｃｔ * FROM `dede_arctype` WHERE id=$ID";
$query = mysql_query($sql);$row=mysql_fetch_array($query); $relID = "$row[reid]"; if($relID == 0) {
@me = $row[typename];}else{$sql = "ｓｅｌｅｃｔ `typename` FROM `dede_arctype` WHERE id=$relID";
$query = mysql_query($sql);$row=mysql_fetch_array($query); @me = $row[typename];}{/dede:field.typeid