VIP福利
主页 > 建站问题 > 织梦DEDECMS根据下级栏目获得顶级栏目名称

织梦DEDECMS根据下级栏目获得顶级栏目名称

SQL语句语句实现

{dede:field.typeid runphp='yes'}$ID = @me; $sql = "SELECT * FROM `58pic_arctype` WHERE id=$ID";

$query = mysql_query($sql);$row=mysql_fetch_array($query); $relID = "$row[reid]"; if($relID == 0) {

@me = $row[typename];}else{$sql = "SELECT `typename` FROM `58pic_arctype` WHERE id=$relID";

$query = mysql_query($sql);$row=mysql_fetch_array($query); @me = $row[typename];}{/dede:field.typeid