$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";