dedecms织梦dede:channel里面调用文章列表

muban大师

{dede:channel type='son' noself='yes'}
[field:id runphp=yes,
global $dsql;
$sql = "SELECT arc.* FROM `mydiy_archives` arc where arc.arcrank>-1 AND arc.typeid = @me ORDER BY arc.id desc limit 10";
$dsql->SetQuery($sql);
$dsql->Execute('t');
$result = '';
while($row = $dsql->GetArray('t'))
{
$arcurl = GetOneArchive($row['id',);
$pubdate = MyDate('m-d',$row['pubdate',);
$result .= [url=,{$row['title',}{$pubdate}[/url]
TPL;
}
@me = $result;
[/field:id,
{/dede:channel}