比如在文章内调用当前作者发布的游戏
{dede:sql sql="SELECT * FROM #@_game mid=~mid~ and flag= 'p' order by aid desc limit 4"}
<li><a href='[field:id runphp='yes'] $id=@me@me=''$url=GetOneArchive($id)@me=$url['arcurl'][/field:id]' title="[field:title/]" target="_blank">[field:title function=cn_substr(@me,20,0)/]</a></li>{/dede:sql}
{dede:list}<img src="[field:pic1/]" ><img src="[field:pic2/]"><img src="[field:pic3/]">
{/dede:list}
select arc.id,arc.typeid,arc.senddate,arc.flag,arc.ismake,arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,tp.typename, ch.typename as channelname,nt.*
from `#@__archives` arc
left join `#@__arctype` tp on tp.id=arc.typeid
left join `#@__channeltype` ch on ch.id=arc.channel
left join `#@__addon17` nt on nt.aid=arc.id
$whereSql order by arc.senddate desc
试试吧,没有MYSQL环境,不知道是否有错误
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)