dedecms按栏目名首字母/数字排序输出的实现方法

SELECT substr(typename,1,1) FROM `dede_arctype` WHERE topid>0 

update `dede_arctype` set first_word=substr( typename,1,1) 

function getfristword( $tid ) 
{ 
$str =''; 
$tid = intval( $tid ); 
$dsql = new Dedesql(false); 
$sql ="select `first_word` from dede_arctype where topid='$tid' group by first_word";
$dsql->SetQuery($sql); 
$dsql->Execute('hw'); 
while($row=$dsql->GetArray('hw')) 
{ 
if($row['first_word']) 
{ 
$wd =$row['first_word']; 
$sql = "select * from dede_arctype where topid=$tid and first_word= '$wd' "; 
$dsql->SetQuery($sql); 
$dsql->Execute('wd'); 
$str .='<div class="ku1_left">'.strtoupper($wd).'开头</div>'; 
while( $rs = $dsql->GetArray('wd') ) 
{ 
$str .='<a href="'.str_replace('{cmspath}','',$rs['typedir']).'" title="'.str_replace('下载','',$rs['typename']).'手机主题" target="_blank">'.$rs['typename'].'</a>'; 
} 
} 
} 
return $str; 
} 

{dede:field.id function="getfristword(@me)"/} 这里是讲把当前栏目的id给getfirestword()；