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

<?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;

?>