dedecms调用最新注册用户名【自定义标签】
作者：邪恶的小鱼 发布时间：February 10, 2010 分类：dedecms
dedecms调用最新注册用户名代码如下
<font color="#FF0000">{dede:sql sql="SELECT max(mid) AS c FROM dede_member "}
[field:c /]
{/dede:sql}</font> 位会员 <a href="../member/index.php?uid=<?php
$row=$dsql->GetOne("SELECT max(mid) AS c FROM dede_member ");
$row2=$dsql->GetOne("SELECT max( userid ) AS u FROM dede_member where mid=".$row['c']);
echo $row2['u'];
?>" class="username">
<?php
$row=$dsql->GetOne("SELECT max(mid) AS c FROM dede_member ");
$row2=$dsql->GetOne("SELECT max( userid ) AS u FROM dede_member where mid=".$row['c']);
echo $row2['u'];
?>
</a>显示效果
1000位会员 小宝