想做个根据(评论平均评分、点赞量、评论量、浏览量、收藏量)综合排序,但是没有效果,order=avgsort,support,hits,comments,favorites 现在是谁在第一个就按谁排序,没有按顺序排序,想问一下,怎么才能让order中的排序字段都生效!让这些排序数量最大的显示到最前面
<ul>
{module module=brand catid=9 num=10 order=avgsort,support,hits,comments,favorites}
<li><a href="{$t.url}" title="{$t.title}" target="_blank">{$t.title}</a><span>{$t['support']+$t['hits']+$t['favorites']+$t['comments']+$t['avgsort']}</span></li>
{/module}
</ul>
<ul> {php $data=dr_linkage('industry', $t.id);} <?php $query=urlencode('SELECT * FROM `dr_1_brand` WHERE `dr_1_brand`.`catid` = 9 AND (`dr_1_brand`.`industry` IN ('.$data.childids.')) ORDER BY (support + avgsort + hits + comments + favorites) DESC LIMIT 10;');?> {sql sql='$query'} <li><a href="{$t.url}" title="{$t.title}" target="_blank">{$t.title}</a><span>{$t['support']+$t['hits']+$t['favorites']+$t['comments']+$t['avgsort']}</span></li> {/sql} {$debug} </ul>