Reed
2015-09-28, 09:46 PM
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>
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>