简单多表查询
- WBOYOriginal
- 2016-06-07 11:44:451039browse
一个简单多表查询//如果需要进行分页的话,和平时操作一样,没有区别<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元
Statement：
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
Previous article：VailData新版本发布Next article：简单的下载文件函数