聯(lián)系官方銷售客服
1835022288
028-61286886
投訴
已解決 如果多表合并查詢 3個(gè)以上？
11 0
模板標(biāo)簽里面
如果多表合并查詢 3個(gè)以上？
{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>責(zé)編：{$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分頁：已開啟當(dāng)前頁：5總頁數(shù)：5每頁數(shù)量：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
現(xiàn)在只能調(diào)出
select * from dr_1_zikao union all select * from dr_1_chengkao 的結(jié)果
union all如何多個(gè)表合并呢？
只能用這種sql標(biāo)簽，來寫原始的查詢語句，但效率會(huì)很低，建議問問數(shù)據(jù)庫(kù)設(shè)計(jì)人員看看怎么寫sql才合理
回復(fù)迅睿框架創(chuàng)始人 {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 '}
<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>責(zé)編：{$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里加這個(gè)分頁會(huì)報(bào)一堆錯(cuò)，不用這個(gè)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>責(zé)編：{$t.author}</span> <span>{dr_date($t['_updatetime'], 'Y-m-d')}</span> </div> </div> </li> {/sql}{$debug}這里能同時(shí)查詢5個(gè)表，但是分頁報(bào)錯(cuò)
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如下簡(jiǎn)單的查詢就能分頁
{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>責(zé)編：{$t.author}</span> <span>{dr_date($t['_updatetime'], 'Y-m-d')}</span> </div> </div> </li> {/sql}{$debug}union all 聯(lián)合查詢不能使用select *，需要共同字段才可以，看看SQL文檔是怎么說的，哈哈，select改成指定字段
回復(fù)@二開/定制/使用解答專家 按你這個(gè)帖子方法改的http://www.zbshanke.com/wenda/8050.html 我這幾個(gè)表字段都是相同的 *也能調(diào)用出來，就是不能用迅睿的方法分頁
{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>責(zé)編：{$t.author}</span> <span>{dr_date($t['_updatetime'], 'Y-m-d')}</span> </div> </div> </li> {/sql}{$debug}上面上修改后的 下面是報(bào)錯(cuò)
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]}分頁就報(bào)錯(cuò)
簡(jiǎn)單啊
回復(fù)@二開/定制/使用解答專家 大佬幫下忙吧 ，同樣用select * from dr_1_zikao union select * from dr_1_dianda union select * from dr_1_zsben union select * from dr_1_chengkao union select * from dr_1_yuanch union select * from dr_1_zsben union來合并數(shù)據(jù)表，加上
就只能調(diào)用第一第二個(gè)表的數(shù)據(jù)，能分頁，去掉
就能調(diào)用全部五個(gè)表數(shù)據(jù) 怎么解決這兩個(gè)沖突呢