方法1、（不带头像）[e:loop={“select * from [!db.pre!]enewsfava where classid=’$navinfor[classid]’ and id=’$navinfor[id]’ group by userid limit 10″,1,24,0}]<li><a href=”[!–news.url–]e/space/?userid=<?=$bqr[userid]?>” target=”_blank”><h5><?=$bqr[username]?></h5></a></li>[/e:loop]
方法1、（带头像）[e:loop={“select a.*,b.* from [!db.pre!]enewsfava a LEFT JOIN [!db.pre!]enewsmemberadd b ON a.userid=b.userid where classid=’$navinfor[classid]’ and id=’$navinfor[id]'”,0,24,0}]<li><a href=”[!–news.url–]e/space/?userid=<?=$bqr[userid]?>” target=”_blank”><img src=”<?=$bqr[userpic]?>”><h5><?=$bqr[username]?></h5></a></li>[/e:loop]