php - 在 MYSQL 和 PDO 中使用 HAVING COUNT 显示重复数据

Question

我需要显示一个表中行中类似数据的计数以制作报告，我已经有了这个脚本，但无法使其工作...我看到使用 HAVING COUNT 我可以显示重复的数据和计数形式行但我可以做到

<ul>
    <? 
        $select_product_dups = $conn->prepare("SELECT id_diagnosticon, diagnostico, diagnostico1, diagnostico2, diagnostico3 FROM DIAGNOSTICON GROUP BY diagnostico HAVING count(diagnostico)>1 AND diagnostico1 HAVING count(diagnostico1)>1 AND diagnostico2 HAVING count(diagnostico2)>1 AND diagnostico3 HAVING count(diagnostico3)>1");
        $select_product_dups->setFetchMode(PDO::FETCH_ASSOC);
        $select_product_dups->execute();
        while ($row = $select_product_dups->fetch()){
        echo '<li id="item_'.$row["id_diagnosticon"].'">';
        if (!empty($row["diagnostico"]))
        {
            echo $row["diagnostico"]; echo '<br><br>';
        }
        if (!empty($row["diagnostico1"]))
        {
            echo $row["diagnostico1"]; echo '<br><br>';
        }
        if (!empty($row["diagnostico2"]))
        {
            echo $row["diagnostico2"]; echo '<br><br>';
        }
        if (!empty($row["diagnostico3"]))
        {
            echo $row["diagnostico3"]; echo '<br><br>';
        }echo '</li>';
        }
    ?>
</ul>

我需要像这样显示数据(如果可以的话显示图表也将是完美的):

• 牛皮癣4
• 痤疮20
• 癌2
• 黑色素瘤5

数据(牛皮癣、痤疮...等)是医生插入的数据

Answer 1

将 SQL 更改为如下所示:-

SELECT id_diagnosticon, diagnostico, COUNT(diagnostico1), COUNT(diagnostico2), COUNT(diagnostico3) 
FROM DIAGNOSTICON 
GROUP BY id_diagnosticon, diagnostico 
HAVING COUNT(diagnostico1)>1 AND COUNT(diagnostico2)>1 AND COUNT(diagnostico3)>1

但是这是假设您需要计算哪些以及您想要分组的