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