dedecms 模板上写sql

最新推荐文章于 2022-06-17 18:10:37 发布

原创最新推荐文章于 2022-06-17 18:10:37 发布 · 905 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #table #list

php 专栏收录该内容

54 篇文章

订阅专栏

{dede:sql sql="Select mid,userid,uname,jointime from `#@__member` where matt=1 and mtype='企业' order by logintime desc limit 19"} <li><a href="[field:global.cfg_memberurl/]/index.php?uid=[field:userid/]" mce_href="[field:global.cfg_memberurl/]/index.php?uid=[field:userid/]" target='_blank' title='[field:uname/]'>[field:uname/]</a></li> {/dede:sql}

{dede:loop table='dede_sys_enum' sort='evalue' sortway='asc' row='10' if="evalue%500 = 0 and egroup ='infotype'"} <li><a href="/list_[field:evalue/]_0_0_1.html" mce_href="list_[field:evalue/]_0_0_1.html" target="_blank">[field:ename/]</a></li> {/dede:loop}