同时查询3个表数据,最后按时间排序展示出来,目前限制了数据总共条数,但是不知道咋做分页,求帮忙!
```php
if($apiid==2927){
$listcount=256;//总共调用多少条数据
$openfids=array(2,36,70);//调用的版块id
//第一个表数据
$videodatas=DB::fetch_all('select * from '.DB::table('video_data').' where status=1 order by dateline DESC limit '.$listcount,$start,$ppp);
$list=$vids=array();
foreach($videodatas as $k=>$v){
$list[$v['vid']]['id']=$v['vid'];
$vids[]=$v['vid'];
$list[$v['vid']]['title']=$v['title'];
}
//第二个表数据
$fidnames=C::t('forum_forum')->fetch_all_name_by_fid($openfids);
$newthreads=C::t('forum_thread')->fetch_all_by_fid_displayorder($openfids, $displayorder = 'dateline', $dateline = null, $recommends = null, $start = 0, $limit =$listcount,$start,$ppp , $order = 'dateline', $sort = 'DESC', $dglue = '>=');
$list1=$tids=array();
foreach($newthreads as $k=>$v){
$list1[$v['tid']]['id']=$v['tid'];
$tids[]=$v['tid'];
$list1[$v['tid']][title]=$v['subject'];
}
$lists=array_merge($list1,$list);
$datelines=array();
foreach($lists as $k=>$v){
$lists[$k]['cover']=$v['cover']?$v['cover']:'';
$datelines[$k]=$v['dateline'];
}
arsort($datelines);
global $tvlist;
$tvlist=array();
$ii=0;
$jsonarr=array(
'code'=>1,
'message'=>'success',
'tvlist'=>$tvlist,
'pagenav'=>$tvlist,
);
}
```