{dede:channel type='son' noself='yes'}

[field:id runphp=yes]

global $dsql;

$sql = "SELECT arc.* FROM `dede_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

<dt><a href="{$arcurl['arcurl']}"><span class="aa2">{$row['title']}</span><span class="aa3">{$pubdate}</span></a></dt>

TPL;

}

@me = $result;

[/field:id]

{/dede:channel}