[e:loop={"select a.*,b.* from [!db.pre!]enewsmember a LEFT JOIN [!db.pre!]enewsmemberadd b ON a.userid=b.userid order by lasttime desc limit 100",100,24,0}] 会员头像:-- 会员空间地址:<?=$bqr['newsurl']?>e/space/?userid=<?=$bqr[userid]?>-- 会员ID:<?=$bqr[userid]?>-- 用户名:<?=$bqr[username]?>-- 注册时间:<?=format_datetime($bqr[registertime],'Y-m-d H:i:s')?>-- 真实姓名:<?=$bqr[truename]?>-- 最近登陆时间:<?=format_datetime($bqr[lasttime],'Y-m-d H:i:s')?> -- 最近登陆的IP:<?=$bqr[lastip]?>-- 登陆次数:<?=$bqr[loginnum]?>-- 会员QQ:<?=$bqr[oicq]?>
select a.*,b.truename as writer,b.userpic as befrom from phome_ecms_news as a LEFT JOIN phome_enewsmemberadd as b ON a.userid=b.userid order by newstime desc limit 100
“order by newstime desc”部分定义排序方式,“limit 100”部分定义查询记录数,自定义列表中可不定义。
[e:loop={'select a.*,b.truename as writer,b.userpic as befrom from phome_ecms_news as a LEFT JOIN phome_enewsmemberadd as b ON a.userid=b.userid order by newstime desc limit 100',0,24,0}]