联系官方销售客服
1835022288
028-61286886
开发框架
版主：迅睿框架研发组
如果多表合并查询 3个以上？
模板标签里面
如果多表合并查询 3个以上？
{sql sql='select * from dr_1_zikao union all select * from dr_1_chengkao union all select * from dr_1_zsben union all select * from dr_1_dianda union all select * from dr_1_yuanch' page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]}
<li>
<div class="list_l_b_img fl">
<img src="{dr_thumb($t['thumb'], 135, 75)}" alt="">
</div>
<div class="list_l_b_tit fl">
<h3><a href="{$t['url']}">{$t['title']}</a></h3>
<div class="list_zbrq">
<span>责编：{$t.author}</span>
<span>{dr_date($t['_updatetime'], 'Y-m-d')}</span>
</div>
</div>
</li>
{/sql}{$debug}SQL: select * from dr_1_zikao union all select * from dr_1_chengkao union all select * from dr_1_zsben union all select * from dr_1_dianda union all select * from dr_1_yuanch LIMIT 8,2总记录：9分页：已开启当前页：5总页数：5每页数量：2分页地址：index.php?s=info&c=category&id=1&page=[page]可用字段：id、catid、title、thumb、keywords、description、hits、uid、author、status、url、link_id、tableid、inputip、inputtime、updatetime、comments、avgsort、displayorder、related、area
现在只能调出
select * from dr_1_zikao union all select * from dr_1_chengkao 的结果
union all如何多个表合并呢？
<li>
<div class="list_l_b_img fl">
<img src="{dr_thumb($t['thumb'], 135, 75)}" alt="">
</div>
<div class="list_l_b_tit fl">
<h3><a href="{$t['url']}">{$t['title']}</a></h3>
<div class="list_zbrq">
<span>责编：{$t.author}</span>
<span>{dr_date($t['_updatetime'], 'Y-m-d')}</span>
</div>
</div>
</li>
{/sql}{$debug} 这样可以查询 但是 page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page] sql里加这个分页会报一堆错，不用这个sql语句可以查询 也能分页 不知道这里为什么不能分页了
{sql sql='select * from ((select * from dr_1_zikao order by updatetime desc) union all (select * from dr_1_chengkao order by updatetime desc) union all (select * from dr_1_zsben order by updatetime desc) union all (select * from dr_1_dianda order by updatetime desc) union all (select * from dr_1_yuanch order by updatetime desc)) as temp order by updatetime desc ' page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]} <li> <div class="list_l_b_img fl"> <img src="{dr_thumb($t['thumb'], 135, 75)}" alt=""> </div> <div class="list_l_b_tit fl"> <h3><a href="{$t['url']}">{$t['title']}</a></h3> <div class="list_zbrq"> <span>责编：{$t.author}</span> <span>{dr_date($t['_updatetime'], 'Y-m-d')}</span> </div> </div> </li> {/sql}{$debug}这里能同时查询5个表，但是分页报错mysqli_sql_exception #1054 Unknown column 'updatetime' in 'order clause' SELECT count(*) as c FROM ((SELECT count(*) as c FROM dr_1_zikao order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_chengkao order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_zsben order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_dianda order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_yuanch order by updatetime desc)) as temp order by updatetime desc如下简单的查询就能分页{sql sql='select * from dr_1_zikao union all select * from dr_1_chengkao' page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]} <li> <div class="list_l_b_img fl"> <img src="{dr_thumb($t['thumb'], 135, 75)}" alt=""> </div> <div class="list_l_b_tit fl"> <h3><a target="_blank" href="{$t['url']}">{$t['title']}</a></h3> <div class="list_zbrq"> <span>责编：{$t.author}</span> <span>{dr_date($t['_updatetime'], 'Y-m-d')}</span> </div> </div> </li> {/sql}{$debug}{php $query=' select * from ((select title,thumb,updatetime,author from dr_1_zikao order by updatetime desc) union all (select title,thumb,updatetime,author from dr_1_chengkao order by updatetime desc) union all (select title,thumb,updatetime,author from dr_1_zsben order by updatetime desc) union all (select title,thumb,updatetime,author from dr_1_dianda order by updatetime desc) union all (select title,thumb,updatetime,author from dr_1_yuanch order by updatetime desc)) as temp order by updatetime desc ';} {sql sql='$query' page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]} <li> <div class="list_l_b_img fl"> <img src="{dr_thumb($t['thumb'], 135, 75)}" alt=""> </div> <div class="list_l_b_tit fl"> <h3><a href="{$t['url']}">{$t['title']}</a></h3> <div class="list_zbrq"> <span>责编：{$t.author}</span> <span>{dr_date($t['_updatetime'], 'Y-m-d')}</span> </div> </div> </li> {/sql}{$debug}上面上修改后的 下面是报错mysqli_sql_exception #1054 Unknown column 'updatetime' in 'order clause' SELECT count(*) as c FROM ((SELECT count(*) as c FROM dr_1_zikao order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_chengkao order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_zsben order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_dianda order by updatetime desc) union all (SELECT count(*) as c FROM dr_1_yuanch order by updatetime desc)) as temp order by updatetime desc\dayrui\System\Database\MySQLi\Connection.php at line 330 323 $this->connID->next_result();324 if ($res = $this->connID->store_result())325 {326 $res->free();327 }328 }329 330 return $this->connID->query($this->prepQuery($sql));331 }332 333 //--------------------------------------------------------------------334 335 /**336 * Prep the query337 *大哥帮忙看看有什么办法能分页吗{sql sql='$query' page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]}分页就报错