下面跟大家谈的是关于如何在在高级搜索页面advancedsearch.php调用自定义字段方法： 步骤： 找到advancedsearch.php页面。 $query = select main.id as aid,main.*,main.description as description1, type.* from $maintable main left join dede2_arctype type on type.id=main.typeid left join $addontable addo […]
$query = "select main.id as aid,main.*,main.description as description1, type.* from $maintable main left join dede2_arctype type on type.id=main.typeid left join $addontable addon on addon.aid=main.id $where $orderby";
改成
$query = "select main.id as aid,main.*,main.description as description1, type.* ,addon.*
from $maintable main
left join dede2_arctype type on type.id=main.typeid
left join $addontable addon on addon.aid=main.id
$where $orderby";
