織夢DEDECMS會員空間全站最熱文章調(diào)用代碼

織夢會員空間全站最熱文章調(diào)用代碼

<?php
    $sql = "SELECT * FROM `#@__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;
?>

織夢會員空間全站最新文章調(diào)用代碼

<?php
    $sql = "SELECT * FROM `#@__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;
?>