织梦advancedsearch.php高级自定义模型字段无法调用解决方案

 

 

$query = "SELECT addon.*, arctype.* FROM $addontable addon   

        LEFT JOIN 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 type ON type.id = main.typeid   

    LEFT JOIN $addontable addon ON addon.aid = main.id   

    $where  $orderby";  

 

 

如果是5.7以前的版本

$query = "SELECT addon.*, arctype.* FROM $addontable addon  

这一段是没有 addon 的！

复制这段加上即可！

 

2 然后 再改这段

 

else {   

       $query = "SELECT main.id AS aid,main.*,main.description AS description1, type.* 

   FROM $maintable main   

   LEFT JOIN type ON type.id = main.typeid   

   LEFT JOIN $addontable addon ON addon.aid = main.id   

   $where  $orderby";  

 

5.7所有的版本 都要改这段 改成：

else {   

  $query = "select addon.*,main.id as aid,main.*,main.description as description1, type.*

from $maintable main