dedeCMS织梦模板按自己写的ID进行栏目排序的教程

$dsql->SetQuery("SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath FROM `dede_arctype` WHERE $tpsql ORDER BY sortrank ASC LIMIT $totalnum"); 

$dsql->SetQuery("SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath FROM `dede_arctype` WHERE $tpsql ORDER BY substring_index('$typeid',id,1) LIMIT $totalnum"); 

{dede:channelartlist typeid='1,2,3,4,5,6'} 
{dede:type} 
<li><a href='[field:typeurl/]' [field:rel/]>[field:typename/]</a></li> 
{/dede:type} 
{/dede:channelartlist}