织梦会员空间全站最新文章调用代码
<?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;?>
<?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;?>
