免费观看又色又爽又黄的忠诚|免费看黄a级毛片成人片|免费看三级片久久|免费鲁丝无码一级|免费全部黄A片免费播放|免费人成视频在线

回復(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里加這個分頁會報一堆錯，不用這個sql語句可以查詢 也能分頁 不知道這里為什么不能分頁了

回復(fù)@二開/定制/使用解答專家 按你這個帖子方法改的http://223987.com/wenda/8050.html 我這幾個表字段都是相同的 *也能調(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}

上面上修改后的 下面是報錯

		

			
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      *
			

大哥幫忙看看有什么辦法能分頁嗎

回復(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ù)表，加上

page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]

就只能調(diào)用第一第二個表的數(shù)據(jù)，能分頁，去掉

page=1 pagesize=2 urlrule=index.php?s=info&c=category&id=1&page=[page]

就能調(diào)用全部五個表數(shù)據(jù) 怎么解決這兩個沖突呢