dedecms 模板上 写sql

{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}