织梦会员空间全站热门文章及最新文章调用代码

<?php    $sql = "SELECT * FROM `dede_archives` WHERE arcrank > -1 ORDER BY click desc LIMIT 10";$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']);$row['litpic'] = $row['litpic'] = $row['litpic']=='' ? '/images/defaultpic.gif' : $row['litpic'];$result .= "<li><a href=/"{$row['arcurl']}/"><img src=/"{$row['litpic']}/">{$row['title']}</a></li>";}echo $result;?>

<?php    $sql = "SELECT * FROM `dede_archives` WHERE arcrank > -1 ORDER BY click id LIMIT 10";$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']);$row['litpic'] = $row['litpic'] = $row['litpic']=='' ? '/images/defaultpic.gif' : $row['litpic'];$result .= "<li><a href=/"{$row['arcurl']}/"><img src=/"{$row['litpic']}/">{$row['title']}</a></li>";}echo $result;?>