调用所有的栏目并按字母排序

[Reed]

order by fieldname：
order by 这个英文名字所在的字段名 如 order by fieldname，帝国cms栏目字段名称是classname, 我们就用order by classname,完整代码：

<ul>
[e:loop={'select classid,classname,classpath,wburl from [!db.pre!]enewsclass where bclassid=0 and showclass=0 order by classname',0,24,0}]
        <li><a href="<?php
if(empty($bqr[wburl]))
{
       echo $public_r[newsurl].$bqr[classpath];
} else {
       echo $bqr[wburl];
}
?>" title="<?=$bqr[classname]?>" target="_self"><?=$bqr[classname]?></a></li>[/e:loop]
</ul>