织梦cms文章页调用父父的子栏目下的文章

{dede:arclist row='1'}
[field:id runphp='yes']
    $tsql = new DedeSql(false);
    $titlelink = '';
    $tsql->SetQuery("SELECT tp.title, tp.typeid2 FROM dede_archives as tp where tp.id=@me");
    $tsql->Execute('tp');
    $row = $tsql->GetArray('tp',MYSQL_ASSOC);
    $title = $row['title'];
    $typeid2 = $row['typeid2'];
    $tsql->SetQuery("SELECT ap.id FROM dede_archives as ap where ap.typeid2='$typeid2' AND ap.flag LIKE '%u%'");
    $tsql->Execute('ap');
    $row2 = $tsql->GetArray('ap',MYSQL_ASSOC);
    $id = $row2['id'];
    if(!empty($id)){
    $titlelink .= "注意";
    }
    @me=$titlelink;
[/field:id]
{/dede:arclist}
///typeid2要自己设置，哈哈

365康大夫网