俗已入骨
- 俗已入骨 2017-03-14 已签到连续签到2天,获得了10个金钱
- 俗已入骨 回答了问题 session 冲突
求人解决 拜托拜托
- 俗已入骨 提出了问题session 冲突
- 俗已入骨 2017-03-13 已签到连续签到1天,获得了5个金钱
$sql = "SELECT user_id,SUM(consumption) as consumption,SUM(achievement) as achievement,SUM(total_bonus) as total_bonus,SUM(fudao_prize) as fudao_prize,SUM(a_bonus) as a_bonus,SUM(income) as income FROM ol_bonus GROUP BY user_id"; $command = $connection->createCommand($sql)->queryAll(); ...count($command)...
这里把
$sql
改成$sql = "select count(distinct user_id) from ol_bonus"
更好吧这样只能取数据的个数,不能取数据的总和。
- 俗已入骨 提出了问题yii原始sql语句分页
- 俗已入骨 发布了话题想知道yii原生sql语句怎么分页?