上一篇
下一篇
读取 某个作者的所有文章
作者:无法显示 日期:2008-08-28
SQL代码
- Select a.*,f.url
- FROM #@__archives a
- left join #@__full_search f on a.ID = f.aid
- Where writer = 'dede'
- ORDER BY a.pubdate DESC"
DEDE模板代码
- {dede:sql sql="Select a.*,f.url FROM #@__archives a left join #@__full_search f on a.ID = f.aid Where writer = 'dede' ORDER BY a.pubdate DESC"}
- ·<a href="[field:arcurl/]">[field:title/]</a>([field:pubdate function=strftime('%m-%d',@me)/])<br/>
- {/dede:sql}
文章来自: 
引用通告: 
Tags: 评论: 1 | 引用: 0 | 查看次数: -
小杰哥哥[2008-10-31 01:20 PM | 
]发表评论