|
板凳
楼主 |
发表于 2014-2-15 11:21:55
|
只看该作者
advancedsearch.php
复制代码
- $query = "select main.id as aid,main.*,main.description as description1, type.*
- from $maintable main
- left join #@__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 #@__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.*"
考虑性能,如果没必要就不要搜索这些字段了
|
|