用户信息排行调用怎么写调出全部会员名
迅睿框架 更新 2024-04-01 18:26:08
星宸
星宸
求教，这个代码，怎么写才能把所有的用户调出来，现在只能调出有投稿的会员信息，0投稿的调不出来
<?php $query=urlencode('SELECT uid, COUNT(*) AS total FROM `@#1_news_index` WHERE status=9 and uid in (select id from @#member_data where pxssfl=1) GROUP BY uid ORDER BY total DESC');?>
{sql sql='$query'}
{php $member = dr_member_info($t.uid);}
{$member.username}
{/sql}
