控制器:
$newsImage = array();
$newsImage = NewsModel::AllList('','news.uptime desc','1');//最新音译
$this->assign('newsImage', $newsImage);
return $this->fetch();Model: $list = array();
$list=db('news')
->where($where)
->field('news.id,news.name,news.click,news.pic,news.addtime,news.uptime,type.name as typename')
->alias('news')
->where('news.hid','0')
->where('news.did','0')
->join('tm_news_type type','news.cid=type.id')
->order($order)
->paginate($limit);
return $list; 最佳答案