联系官方销售客服
QQ1835022299
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]}
{$t['title']}
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如何多个表合并呢？
{$t['title']}
责编：{$t.author}
{dr_date($t['_updatetime'], 'Y-m-d')}
{/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]}{$t['title']}
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]}{$t['title']}
{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]}{$t['title']}
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]}分页就报错