1.调用最新更新的会员
SELECT * from uchome_space order by updatetime desc
2.调用最近3天注册的会员,按照时间顺序排列
SELECT * FROM uchome_space WHERE
dateline>UNIX_TIMESTAMP()-86400*3 ORDER BY dateline
DESC
3.调用积分最高的会员
SELECT * from uchome_space order by credit desc
4.调用有头像的会员
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`avatar`='1'
5.调用实名认证的会员
SELECT * from uchome_space where `name`!=''
6.调用本周热门会员
SELECT * from uchome_space where `name`!=''
会员调用的SQL方法有很多,也非常灵活,大家可以根据自己的需要去写
也可以去官方论坛搜索:discuz.net