$dsql->SetQuery("Insert Into `dede_keywords`(keyword,rank,sta,rpurl) Values('".addslashes($k)."','$v','1','')"); $dsql->Execute();
8
}
将上面的代码修改为:
01
foreach($wsnew as $k=>$v)
02
{
03
$rpurl="";
04
$myrow = $dsql->GetOne("SELECT distinct concat(replace(b.sitepath,'{cmspath}',''),'/',(case a.filename when '' then a.id else a.filename end),'.html') rpurl FROM dede_archives a,dede_arctype b where a.typeid=b.id And (a.keywords='$k' or a.keywords like'$k,%' or a.keywords like'%,$k'or a.keywords like'%,$k,%') ");
{dede:sql sql='Select * from dede_keywords order by aid} <li>[field:aid/] - <a href='[field:rpurl/]' target='_blank'>[field:keyword/]</a></li> {/dede:sql}