我尝试创建一个基本的评论系统,我很成功,但我现在有问题。
我无法列出"最喜欢的"评论,我对我该如何。
我的投票数据库显示这样的显示:
voteid | value | entryid | userid
25 | like | 257 | 17
24 | like | 257 | 17
23 | unlike | 257 | 18
我使用此代码创建一个新的类似:
$vote = $connect->prepare("INSERT INTO votes (entryid, userid, value) VALUES (:entryid, :userid, :value)");
$vote->bindParam(':entryid', $entryid);
$vote->bindParam(':userid', $userid);
$vote->bindParam(':value', $value);
$vote->execute();
和我的问题。
我的需要SQL查询?
我尝试过这样的尝试:
$bestliked = $connect->prepare("SELECT * FROM votes");
$best = $bestliked->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_COLUMN, 2);
,但我无法列出最子阵列的数组。似乎只有;
[1] => Array
(
[0] => 8
[1] => 2
[2] => 3
[3] => 4
[4] => 5
[5] => 6
[6] => 7
[7] => 9
[8] => 10
[9] => 11
[10] => 12
[11] => 13
[12] => 14
[13] => 15
)
[2] => Array
(
[0] => 16
)
[3] => Array
(
[0] => 17
)
谢谢所有!
您可以尝试总结组计数并对其进行排序:
Select *,count(*) as sum group by entryid where value='like' order by sum desc