织梦CMS根据下级栏目获得顶级栏目名称的SQL语句

根据下级栏目获得顶级栏目名称的SQL语句

代码如下：

1. {dede:field.typeid runphp='yes'}
2. $ID = @me;
3. $sql = "SELECT * FROM `dede_arctype` WHERE id=$ID";
4. $query = mysql_query($sql);
5. $row=mysql_fetch_array($query);
6. $relID = "$row[reid]";
7. if($relID == 0) {@me = $row[typename];}
8. else{
9. $sql = "SELECT `typename` FROM `dede_arctype` WHERE id=$relID";
10. $query = mysql_query($sql);
11. $row=mysql_fetch_array($query);
12. @me = $row[typename];
13. }
14. {/dede:field.typeid} 

以下为更新标签，使用dedesql类操作。

1. {dede:field.typeid runphp='yes'}
2. $ID = @me;
3. global $dsql;
4. $sql = "SELECT * FROM `dede_arctype` WHERE id=$ID";
5. $dsql->Execute('a', $sql);
6. $row = $dsql->GetArray('a');
7. $relID = "$row[reid]";
8. if($relID == 0)
9. {
10. @me = $row[typename];
11. }
12. else{
13. $sql = "SELECT `typename` FROM `dede_arctype` WHERE id=$relID";
14. $dsql->Execute('t', $sql);
15. $row = $dsql->GetArray('t');
16. @me = $row[typename];
17. }
18. {/dede:field.typeid}