{dede:field.field0 runphp=yes}

global $dsql;

$sql = "select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,

tp.defaultname,tp.namerule,tp.moresite,tp.siteurl,tp.sitepath

from `58pic_archives` arc left join `58pic_arctype` tp on arc.typeid=tp.id where tp.id in (@me) LIMIT 10";

$dsql->SetQuery($sql);

$dsql->Execute('t');

$result = '';

while($row = $dsql->GetArray('t'))

{

$arcurl=GetOneArchive($row['id']);

$pubdate = MyDate('Y-m-d H:i:s',$row['pubdate']);

$result .= "<li><span>{$pubdate}</span><a href=\"{$arcurl['arcurl']}\">{$row['title']}</a></li>";

}

@me = $result;

{/dede:field.field0}