织梦DedeCMS模板织梦DedeCMS:channel里面调用文章列表的方法

01
{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 .= <<< TPL

{$row[‘title’]}{$pubdate}

TPL;
}
@me = $result;
[/field:id]
{/dede:channel}