CakePHP SQL查询计数最大限度的审查 [英] CakePHP SQL-query count for maximum review
本文介绍了CakePHP SQL查询计数最大限度的审查的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我如何计算评论，以便我可以根据人气来显示。谁有最高的评论显示首先等等。哪个场地有最高的评论，它会首先显示然后休息。我试过但它的不工作PLZ帮帮我..
以下是我的编码
how can i count the review so that i can display according to popularity.i.e who has heigst review show first and so on.which venue has higest review it will show first and then the rests are.I have tried it but its not working plz help me..
Below is my coding
Array
(
[0] => Array
(
[Venue] => Array
(
[id] => 6
)
[Review] => Array
(
[0] => Array
(
[id] => 9
[rating] => 4
[venue_id] => 6
)
[1] => Array
(
[id] => 10
[rating] => 3
[venue_id] => 6
)
[2] => Array
(
[id] => 11
[rating] => 3
[venue_id] => 6
)
)
)
[1] => Array
(
[Venue] => Array
(
[id] => 15
)
[Review] => Array
(
[0] => Array
(
[id] => 16
[rating] => 5
[venue_id] => 15
)
[1] => Array
(
[id] => 17
[rating] => 4
[venue_id] => 15
)
)
)
[2] => Array
(
[Venue] => Array
(
[id] => 17
)
[Review] => Array
(
[0] => Array
(
[id] => 15
[rating] => 4
[venue_id] => 17
)
)
)
[3] => Array
(
[Venue] => Array
(
[id] => 31
)
[Review] => Array
(
)
)
[4] => Array
(
[Venue] => Array
(
[id] => 32
)
[Review] => Array
(
[0] => Array
(
[id] => 18
[rating] => 1
[venue_id] => 32
)
[1] => Array
(
[id] => 19
[rating] => 1
[venue_id] => 32
)
[2] => Array
(
[id] => 20
[rating] => 1
[venue_id] => 32
)
[3] => Array
(
[id] => 21
[rating] => 1
[venue_id] => 32
)
[4] => Array
(
[id] => 22
[rating] => 1
[venue_id] => 32
)
)
)
)
if ($order == 'popularity') {
$order = array('COUNT(Review) DESC');
}
$this->Paginator->settings = array('conditions' => $conditions, 'limit' => 10, 'order' => $order, 'page' => @$data['page']);
$sqql = $this->Paginator->paginate('Venue');
推荐答案
order == ' 受欢迎程度'）{
order == 'popularity') {
order = array（' COUNT（Review）DESC'）;
}
order = array('COUNT(Review) DESC'); }
this-> Paginator-> settings = array（' 条件 =>
this->Paginator->settings = array('conditions' =>
这篇关于CakePHP SQL查询计数最大限度的审查的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
