select id,content,img,username,(pai+lan) as r from
(select d.id,d.content,d.img,u.username,c.pai,c.lan from data as d left join user as u on d.poster_id=u.id left join count as c on d.id=c.data_id) as h order by r desc这个sql语句我想转换成thinkphp中的连贯查询方式或者视图,因为想要做分页方便
(select d.id,d.content,d.img,u.username,c.pai,c.lan from data as d left join user as u on d.poster_id=u.id left join count as c on d.id=c.data_id) as h order by r desc这个sql语句我想转换成thinkphp中的连贯查询方式或者视图,因为想要做分页方便
解决方案 »
- 响应版主号召,发点入门教学文章 - 简单说下redis主从复制过程以及我发现的一个导致我线上业务出bug的不起眼特性
- 这个界面怎么做?
- 学习ecshop源码的方法
- apache 2.2.3 和 php 5.2.0的使用
- php报表,找了两天一点头绪都没有
- 请问下面的问题怎么解决?
- 求个MySQL的SQL语句,请各位大老帮忙.
- 之前还可以运行的程序,现在不行了
- 研究过discuz论坛源代码的请进!
- 怎么利用循环得到一个无限层次的多维数组?意为:循环1-3-n,得到$var[1][2][3]-[n]的多维数组。
- php 如何获取JS的值 ,新手折腾几天了 还请大侠赐教!
- 求助 memory_get_usage 疑问
$list = $mod->query(select id,content,img,username,(pai+lan) as r from
(select d.id,d.content,d.img,u.username,c.pai,c.lan from data as d left join user as u on d.poster_id=u.id left join count as c on d.id=c.data_id) as h order by r desc)把前缀换一下
2、试一下$subQuery = $model->field(' d.id,d.content,d.img,u.username,c.pai,c.lan ')->join(" data as d left join user as u on d.poster_id=u.id")->join("count as c on d.id=c.data_id")->select(false);
$model->table($subQuery.'h')->order("r desc")->select()
第二个我也没试过, 大概写的, 不知能不能运行