织梦根据“栏目关键词=文章自定义字段名称”条件筛选文章输出

列表页调用

{dede:field.keywords runphp=yes}
global $dsql;
$keyword = @me;
if($keyword != '')
{
    $sql = "SELECT arc.*,addf.* FROM `#@__archives` arc LEFT JOIN `#@__addonarticle17` addf ON arc.id=addf.aid WHERE arc.arcrank>-1 AND addf.ssxx = '$keyword' 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>";
}
@me = $result;
{/dede:field.keywords}

首页调用

{dede:channelartlist typeid='1,1'}

{dede:field.keywords runphp=yes}
global $dsql;
$keyword = @me;
if($keyword != '')
{
    $sql = "SELECT arc.*,addf.* FROM `#@__archives` arc LEFT JOIN `#@__addonarticle17` addf ON arc.id=addf.aid WHERE arc.arcrank>-1 AND addf.ssxx = '$keyword' 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>";
}
@me = $result;
{/dede:field.keywords}

{/dede:channelartlist}

根据栏目关键词调用文章

 {dede:arclist typeid='3' row='2' titlelen='250' channelid=''  orderby='pubdate' keyword='~keywords~'}
                                <li class="layui-elip">
                                    <a href="[field:arcurl/]" target="_blank" style="color: ;" title="[field:title/]"><span class="dot-icon"></span>[field:title/]</a>
                                </li>
   {/dede:arclist}      

实操转化

 {dede:field.keywords runphp=yes}
                    global $dsql;
                    $keyword = @me;
                    if($keyword != '')
                    {
                        $sql = "SELECT arc.*,addf.* FROM `#@__archives` arc LEFT JOIN `#@__addonarticle18` addf ON arc.id=addf.aid WHERE arc.arcrank>-1 AND addf.jsssxx = '$keyword' 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 .= "<tr><td class=\"major-td\"><em class=\"tag tag7\">{$row['jzssfl']}</em>
                        <a href=\"{$row['arcurl']}\">{$row['sszy']}</a>
                    </td>
                    <td class=\"project-td\"><a href=\"{$row['arcurl']}\" >{$row['zyfx']}</a></td>
                    <td class=\"time-td\">{$row['xz']}</td>
                    <td class=\"type-name-td\">{$row['skfs']}</td>
                    <td class=\"area-td\">{$row['skdd']}</td>
                    <td class=\"certificate-td\">
                       <em class=\"zs-tag yuloo-renmindaxuezs-tag1 zs-tag1\">{$row['hdzs']}</em>
                     </td>
                      <td class=\"price-td\">{$row['xf']}</td>
                      <td class=\"btn-td\"><a href=\"{$row['arcurl']}\"><span>查看简章</span></a></td>
               		 </tr>";
                    }
                    @me = $result;
                    {/dede:field.keywords}

根据文章字段名等于栏目关键词的栏目列表

{dede:sql sql="SELECT * FROM `#@__arctype` WHERE keywords = ~zysxxx~"}
            <a href="[field:array runphp=yes]@me = GetOneTypeUrlA(@me);[/field:array]">[field:typename/][field:xxskfs/]</a>
            {/dede:sql}

调用栏目自定义字段名=固定值的栏目列表（包含就行）

 {dede:sql sql="SELECT * FROM #@__arctype WHERE  xxbklx like '%非全日制研究生%' limit 6"}
  
                            <dl>
                                <dt><a href="[field:array runphp=yes]@me = GetOneTypeUrlA(@me);[/field:array]"><img src="[field:addimg/]" alt="[field:typename/]"></a></dt> 
                                <dd><a href="[field:array runphp=yes]@me = GetOneTypeUrlA(@me);[/field:array]" title="[field:typename/]">[field:typename/]</a></dd> 
                            </dl>
                        {/dede:sql}