dedecms datalist搜索页如何调用后台自定义字段内容

发布时间：2021-12-13 14:37 所属栏目：19 来源：互联网

导读：解决...修改advancedsearch.php文件找到如下代码: $query = select arctype.* from $addontable addon left join dede_arctype arctype on arctype.id=addon.typeid $where $orderby; } else { $query = select main.id as aid,main.*,main.description as des

解决...修改advancedsearch.php文件找到如下代码:

$query = "select arctype.* from $addontable addon
  left join dede_arctype arctype on arctype.id=addon.typeid
  $where $orderby";
} else {
  $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";
在select后面增加"addon.*,",修改后应该是如下代码:

$query = "select addon.*, arctype.* from $addontable addon
  left join dede_arctype arctype on arctype.id=addon.typeid
  $where $orderby";
} else {
  $query = "select addon.*,main.id as aid,main.*,main.description as description1, type.* //开源软件:Cuoxin.com
from $maintable main
left join dede_arctype type on type.id=main.typeid
left join $addontable addon on addon.aid=main.id
$where $orderby";
注意,有两个地方要加,显示结果要修改模板文件,在plus/advancedsearch.htm，{dede:datalist}中直接调用{dede:field.字段名称/}就OK了.

（编辑：ASP站长网）