2021-09-21 16:59:40
问题：网站需要在栏目列表页调用上级栏目的名称，也就是在列表模板调用当前栏目的父栏目？
解答：
动态页：
{dede:type}
[field:id runphp=yes]
$tsql = new DedeSql(false);
$typelink2 = '';
$tsql->SetQuery("Select i.typedir,i.id,i.typename From arctype t left join arctype i on i.id=t.reid where t.id='@me'");
$tsql->Execute('t');
while($row = $tsql->GetArray('t',MYSQL_ASSOC))
{
$typelink2 .= "<a href='list.php?tid=".$row['id']."'>".$row['typename']."</a>";
}
@me=$typelink2;
[/field:id]
{/dede:type}
静态页
{dede:type}
[field:id runphp=yes]
$tsql = new DedeSql(false);
$typelink2 = '';
$tsql->SetQuery("Select i.typedir,i.id,i.typename From arctype t left join arctype i on i.id=t.reid where t.id='@me'");
$tsql->Execute('t');
while($row = $tsql->GetArray('t',MYSQL_ASSOC))
{
$typelink2 .= "<a href='".$row['typedir']."'>".$row['typename']."</a>";
}
@me=str_replace("{cmspath}","",$typelink2);
[/field:id]
{/dede:type}
解答：
动态页：
{dede:type}
[field:id runphp=yes]
$tsql = new DedeSql(false);
$typelink2 = '';
$tsql->SetQuery("Select i.typedir,i.id,i.typename From arctype t left join arctype i on i.id=t.reid where t.id='@me'");
$tsql->Execute('t');
while($row = $tsql->GetArray('t',MYSQL_ASSOC))
{
$typelink2 .= "<a href='list.php?tid=".$row['id']."'>".$row['typename']."</a>";
}
@me=$typelink2;
[/field:id]
{/dede:type}
静态页
{dede:type}
[field:id runphp=yes]
$tsql = new DedeSql(false);
$typelink2 = '';
$tsql->SetQuery("Select i.typedir,i.id,i.typename From arctype t left join arctype i on i.id=t.reid where t.id='@me'");
$tsql->Execute('t');
while($row = $tsql->GetArray('t',MYSQL_ASSOC))
{
$typelink2 .= "<a href='".$row['typedir']."'>".$row['typename']."</a>";
}
@me=str_replace("{cmspath}","",$typelink2);
[/field:id]
{/dede:type}
