显示出现次数最多的日期

Question

此脚本返回发布最多笑话的日期以及笑话的数量。问题是，当有两个或更多的约会有相同数量的笑话时。当发生这种情况时，我该如何显示？

当有两个或更多的日期有相同数量的笑话时，我想回想所有的日期。例如:有更多的日子有相同数量的笑话(显示日期)这些天每天发布的笑话是(笑话的数量)

<?php
 $page_title = 'day with most jokes';
include ('includes/header.html');
require ('mysqli_connect.php');


$q="SELECT date, COUNT(date) AS value_occurrence FROM joke GROUP BY date ORDER BY value_occurrence DESC LIMIT";
$r = mysqli_query($dbc, $q) or die(mysql_error());
$row=  mysqli_fetch_row($r);


echo'day <b>' . $row[0] . '</b>is the day with most joke(s) </br>' ;
echo 'on that day there were<b> ' . $row[1] . ' <b> joke(s)';


    ?>

Answer 1

我会将查询更改为：

SELECT * FROM
    (SELECT date, COUNT(date) AS value_occurrence, MAX(value_occurence) AS max_occ
     FROM joke
     GROUP BY date
     ORDER BY value_occurrence DESC)
WHERE value_occurence = max_occ

或者说：

SELECT date, value_occurence, MAX(value_occurence) AS max_occ FROM
    (SELECT date, COUNT(date) AS value_occurrence
     FROM joke
     GROUP BY date
     ORDER BY value_occurrence DESC) sq
WHERE value_occurence = max_occ

然后，在PHP代码中，我将相应地估计返回和显示日期的行数。