Question

dede 自定义字段中使用sql语句调用

Answer 1

{dede:sql sql="Select aid,typeid,title,writer,senddate,body From dede_mynews order by aid desc limit 0,10"}<li class='dotline'><span>[field:senddate function="MyDate('m-d',@me)"/]</span> <a href="/news.php?id=[field:aid/]">[field:title/]</a>[field:body/]</li>{/dede:sql}