根据下级栏目获得顶级栏目名称的SQL语句

发表于2011-03-07 16:16:14来源于深圳创想网页设计工作室

次点击[大] [中] [小] [打印] [关闭窗口] [评论]

{dede:field.typeid runphp='yes'}

$ID = @me;

$sql = "SELECT * FROM `dede_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 `dede_arctype` WHERE id=$relID";

$query = mysql_query($sql);

$row=mysql_fetch_array($query);

@me = $row[typename];

}

{/dede:field.typeid}

{dede:field.typeid runphp='yes'}

$ID = @me;

global $dsql;

$sql = "SELECT * FROM `dede_arctype` WHERE id=$ID";

$dsql->Execute('a', $sql);

$row = $dsql->GetArray('a');

$relID = "$row[reid]";

if($relID == 0)

{

@me = $row[typename];

}

else{

$sql = "SELECT `typename` FROM `dede_arctype` WHERE id=$relID";

$dsql->Execute('t', $sql);

$row = $dsql->GetArray('t');

 

@me = $row[typename];

}

{/dede:field.typeid}

相关热词搜索：栏目SQLDEDECMS$dsql数据库类

上一篇：小技巧：让文章的大图片不破坏布局

下一篇：拓展channel标签实现limit功能