用户自定义字段如何调用
迅睿框架 更新 2024-03-31 22:36:50
星宸
星宸
想用用户自定义字段调用用户的信息和排名，为啥加了字段tuijian，前端调用不出来？
<?php $query=urlencode('SELECT uid, COUNT(*) AS total FROM `@#1_news_index` WHERE status=9 GROUP BY uid ORDER BY total DESC');?>
{sql sql='$query' MONTH_updatetime=0}
{if $t['tuijian'] == "1"}
{php $member = dr_member_info($t.uid);}
<tr>
<td height="40" align="center" style="border: #e9eff8 solid 1px;">{$key+1}</td>
<td align="center" style="border: #e9eff8 solid 1px;"> {$member.username}</td>
<td align="center" style="border: #e9eff8 solid 1px;">{$t.total} 篇</td>
</tr>
{/if}
{/sql}
开源社区插件技术-小鹏
<?php $query=urlencode('SELECT uid, COUNT(*) AS total FROM `@#1_news_index` WHERE status=9 and uid in （select id from @#member_data where tuijian=1） GROUP BY uid ORDER BY total DESC');?> {sql sql='$query'} {php $member = dr_member_info($t.uid);} <tr> <td height="40" align="center" style="border: #e9eff8 solid 1px;">{$key+1}</td> <td align="center" style="border: #e9eff8 solid 1px;"> {$member.username}</td> <td align="center" style="border: #e9eff8 solid 1px;">{$t.total} 篇</td> </tr> {/sql}