调用数据文章

第一种方法

{dede:sql sql=”SELECT * FROM wp_posts where post_status = ‘publish’ and post_type=’post’ order by post_date desc limit 0,10″}<li>
<a href=’[field:guid/]‘ target=’_blank’>[field:post_title /]</a></li>
{/dede:sql}

第二种方法

{dede:sql sql=”select *,id as post_id from wp_posts where post_status=’publish’ order by id desc limit 0,10″}
<li class=’dotline’><a href=’http://www.clseo.com/blog/?p=[field:post_id/]‘ target=’_blank’>[field:post_title/]</a></li>
{/dede:sql}

随机调用

{dede:sql sql=”SELECT * FROM wp_posts where post_status = ‘publish’ and post_type=’post’ order by rand() desc limit 0,100″}
<a href=’[field:guid/]‘ target=’_blank’>[field:post_title /]</a>
{/dede:sql}

//最新日志
post_date
//热评日志
comment_count
//随机日志
rand