$query = "select main.id as aid,main.*,main.description as description1, type.* from $maintable main left join dede_arctype type on type.id=main.typeid left join $addontable addon on addon.aid=main.id $where $orderby";
第二步:修改第一步中的查詢語句,添加自定義字段查詢內(nèi)容,加上“,addon.* ”如下: $query = "select main.id as aid,main.*,main.description as description1, type.* ,addon.* from $maintable main left join dede_arctype type on type.id=main.typeid left join $addontable addon on addon.aid=main.id $where $orderby";