查詢: select a.userid,a.groupid as classid,b.company as title from [!db.pre!]enewsmember a LEFT JOIN [!db.pre!]enewsmemberadd b ON a.userid=b.userid order by a.userid desc 調用: 图片,准备对应会员组id的vip1.gif、vip2.gif……css,对应会员组id的css1、css2…… <img src="/skin/default/images/vip[!--classid--].gif" align="absMiddle" /> <A class="css[!--classid--]" href="/e/space/?userid=[!--userid--]" target=_blank> [!--title--]</a>
|