01 |
{dede:tag row= '30' sort = 'new' getall= '0' } |
03 |
<dl class= "tbox light" > |
04 |
<dt class= 'light' ><strong>[field:tag /]</strong></dt> |
07 |
[field:tag runphp= yes ] |
10 |
$arow = $dsql->GetOne( "Select * From `dede_tagindex` where tag like '$taga'" ); |
14 |
$tagsql = "Select aid From `dede_taglist` where tid = $tid And arcrank > -1 group by aid order by aid desc" ; |
15 |
$dsql->SetQuery($tagsql); |
18 |
while ($arow = $dsql->GetArray( 't' )) |
20 |
$ids[] = $arow[ 'aid' ]; |
25 |
$idsStr = join ( ',' , $ids); |
26 |
$query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, |
27 |
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath |
28 |
from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp. id |
29 |
where arc.arcrank>-1 and arc. id in ($idsStr) And arc. id <>$aid order by arc. id desc limit 10";//输入多少个文章 |
31 |
$dsql->SetQuery($query); |
34 |
$totalRow = $dsql->GetTotalRow(); |
35 |
while ($row = $dsql->GetArray( 't' )) |
37 |
$arcurl = GetOneArchive($row[ 'id' ]); |
38 |
$result .= "<li><a href=" {$arcurl[ 'arcurl' ]} ">{$row['title']}</a></li>" ; |
40 |
if ($result== '' ) $result = "<p style='color:#f00;'>?该TAG标签没有相关文章</p>" ; |
|