<?php 
    $row = $dsql->GetOne("SELECT * FROM `dede_arctype` WHERE id=8");
    echo "<li><a href=".$row['typedir'].">".$row['typename']."</a></li>";
  ?> 

<?php    $sql = "SELECT * FROM `dede_archives` WHERE arcrank > -1 and typeid=8 ORDER BY click desc LIMIT 8";
                $dsql->SetQuery($sql);
                $dsql->Execute('t');
                $result = '';while($row = $dsql->GetArray('t'))
                {
                $arcrow = GetOneArchive($row['id']);
                $row['arcurl'] = $arcrow['arcurl'];
                $row['pubdate'] = MyDate('Y-m-d',$row['pubdate']);
                $result .= "<li><a href=\"{$row['arcurl']}\">{$row['title']}</a></li>";
}
echo $result;?>