dedecms 调用TAG sql二次开发应用

dedecms 调用tag sql二次开发应用
[field:id runphp教程=yes]
                    $tsql = new dedesql(false);
    $tags = '';
    $tsql->setquery("select i.tag from dede_taglist t left join dede_tagindex i on i.id=t.tid where t.aid='@me'");
    $tsql->execute('t');
    while($row = $tsql->getarray('t',mysql教程_assoc)){
       $tags .= "".$row['tag']."";
      
     
    }
    @me=$tags;

                [/field:id]

使用方法
 

 
{dede:list pagesize='10'}    
 
关键词:[field:id runphp=yes]
                    $tsql = new dedesql(false);
    $tags = '';
    $tsql->setquery("select i.tag from dede_taglist t left join dede_tagindex i on i.id=t.tid where t.aid='@me'");
    $tsql->execute('t');
    while($row = $tsql->getarray('t',mysql_assoc)){
       $tags .= "".$row['tag']."";
      
      
    }
    @me=$tags;
 
                [/field:id]
 
{/dede:list}