ݵ

ù˺Ž̨
ν룺߼-ݵ-ģ-дSQL
Ϣд£
ģƣ
ͷ
ݵ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()

дϺȷһ

Ϣд


block1
ʱ䣺
0
ȡĿ
ѡȡĲ
Ȼֱ052
ʾHTML룺
<ul>
<!--{loop $_SBLOCK[block1] $value}-->
<li>
<a href="http://UCHַ/space.php?uid=$value[uid]" title="$value[username]" target="_blank"><!--{avatar($value[uid],small)}--></a></li>
<!--{/loop}-->
</ul>

