织梦DEDECMS首页,列表页及文章页调用tag标签的方法

[field:id runphp=yes]
     $tsql = new DedeSql(false);
     $tags = '';
     $tsql->SetQuery("Select i.tag From ying_taglist t left join ying_tagindex i on i.id=t.tid where t.aid='@me'");
     $tsql->Execute('t');
     while($row = $tsql->GetArray('t',MYSQL_ASSOC)){
       $tags .= "<a href='/tags.php?/".urlencode($row['tag'])."'>".$row['tag']."</a>";       
     }
     @me=$tags;
[/field:id]

//获得某文档的所有tag
function GetTags($aid)
{
 global $dsql;
 $tags = '';
 $query = "Select tag From `ying_taglist` where aid='$aid' ";
 $dsql->Execute('tag',$query);
 while($row = $dsql->GetArray('tag'))
 {
  $tags .= ($tags=='' ? $row['tag'] : ','.$row['tag']);
 }
 return $tags;
}

//获得某文档的所有tag
function GetTags($aid)
{
     global $dsql;
     $tags = '';
     $query = "Select tag From `wmd_taglist` where aid='$aid' ";
     $dsql->Execute('tag',$query);
     while($row = $dsql->GetArray('tag'))
     {
         $tags.= ($tags=='' ? "<a  href=/tags.php?/{$row['tag']} target=_blank>{$row['tag']}</a>" : ','."<a href=/tags.php?/{$row['tag']} target=_blank>{$row['tag']}</a>");
     }
     return $tags;
}