<?php
include_once("../includes/connection.php");
error_reporting(E_ALL ^ E_NOTICE);
$a = 5;
$b = 4;
$c = 3;
$d = 2;
$e = 1;
$query = mysql_query("SELECT overallRating FROM ratings WHERE client_id = 1");
while($row = mysql_fetch_array($query)){
$x = array($row['overallRating']);
foreach($x as $y)
{
if($y == $a){
$count1 = count(preg_split("/[5]/", $y));
}
if($y == $b){
$count2 = count(preg_split("/\d/", $y));
}
if($y == $c){
$count3 = count(preg_split("/\d/", $y));
}
if($y == $d){
$count4 = count(preg_split("/\d/", $y));
}
if($y == $e){
$count5 = count(preg_split("/\d/", $y));
}
}
}
echo $count1."<br>";
echo $count2."<br>";
echo $count3."<br>";
echo $count4."<br>";
echo $count5."<br>";
?>