織夢會員空間全站熱門文章調用代碼
<?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;
?>