mysql实现织梦首页调用dede子栏目的方法

{dede:channelartlist typeid='栏目ID' row='条数'}  
<div class="list"> 
<li><a href="{dede:field name='typeurl'/}">{dede:field name='typename'/}</a></li> 
<ul> 
{dede:sql sql='Select * from dede_arctype where reid=~id~ ORDER BY id limit 0,7'}  
<li><a href='[field:typedir/]' target='_blank'>[field:typename/]</a></li> 
{/dede:sql}  
</ul> 
</div> 
{/dede:channelartlist} 

[field:typedir function='str_replace("{cmspath}","",@me)'/] 

[field:typedir/]
{dede:field name='typedir' runphp='yes'}  
@me=str_replace("{cmspath}","",@me);