Home > php教程 > php手册 > 简单多表查询

简单多表查询

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 11:44:45
Original
1115 people have browsed it

一个简单多表查询
//如果需要进行分页的话,和平时操作一样,没有区别<br>          $Model=new Model();<br>         $this->companyList=$Model<br>             ->table(array(<br>                         C('DB_PREFIX').'company'=>'company',<br>                         C('DB_PREFIX').'meet'=>'meet',<br>                         C('DB_PREFIX').'category'=>'category',<br>                     )<br>               )<br>             ->where('company.meetid=meet.id and company.categoryid=category.id')<br>             ->field('company.* , meet.title , category.category')<br>             ->order('company.meetid desc')<br>             ->select();

AD:真正免费,域名+虚机+企业邮箱=0元

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template