织梦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}