Dedecms 獲得頂級欄目名稱的SQL語句
來源：程序員人生 發(fā)布時間：2013-10-31 03:04:47 閱讀次數(shù)：3943次
Dedecms 獲得頂級欄目名稱的SQL語句
適用于 DEDE5.5
{dede:field.typeid runphp='yes'}$ID = @me; $sql = "SELECT `reid` FROM `dede_arctype` WHERE id=$ID";$query = mysql_query($sql);$row=mysql_fetch_array($query); $relID = "$row[reid]";$sql2 = "SELECT `typename` FROM `dede_arctype` WHERE id=$relID";$query2 = mysql_query($sql2);$row2=mysql_fetch_array($query2); @me = $row2[typename];{/dede:field.typeid}
上面那個不是很完善，當(dāng)欄目本來就是頂級欄目時就得不到了，用這個吧
{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}
