How do I count particular values from database and display it? Now I have different feedback such like Excellent, Very Good, Good etc. It's basically a feedback form which ratings based
<?php
$sql_query_very_good = "SELECT *,COUNT(*) AS very_good_count FROM visitors_feedback
WHERE question01_answer LIKE '%Very Good%'
OR question02_answer LIKE '%Very Good%'
OR question03_answer LIKE '%Very Good%'
OR question04_answer LIKE '%Very Good%'
OR question05_answer LIKE '%Very Good%'
OR question06_answer LIKE '%Very Good%'
";
$result_very_good = mysqli_query($db, $sql_query_very_good);
while($view_very_good = mysqli_fetch_assoc($result_very_good)):
?>
<td><?php echo $view_very_good['very_good_count']; ?></td>
<?php endwhile; ?>