織夢后臺文章列表中顯示自定義字段

$whereSql = empty($channelid) ? " WHERE arc.channel > 0 AND arc.arcrank > -2 " : " WHERE arc.channel = '$channelid' AND arc.arcrank > -2 ";

$query = "SELECT arc.id,arc.typeid,arc.senddate,arc.flag,arc.ismake,arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.midFROM `$maintable` arc$whereSqlORDER BY $orderbyField DESC";

$query = "SELECT arc.id,arc.typeid,addon.huohao,arc.flag,arc.ismake,arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.midFROM `$maintable` arc,`dede_addonarticle` addon,`dede_arctype` act where (arc.id=addon.aid) and (arc.typeid=act.id)$whereSqlORDER BY $orderbyField DESC";