sql语句
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS
`spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`avatar`='1' ORDER BY RAND()
复制代码SQL
调用html代码
<ul class="avatar_list"> <!--{loop $_SBLOCK['block9'] $value}-->