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

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 title="'.str_replace('下载','',$rs['typename']).'手机主题" target="_blank">'.$rs['typename'].'</a>';
}
}
}
return $str;
}

写好后，我们找到调用栏目的模板
jx.html里面这样写