I have a list that is created from a mysql field that is exploded into a list
$calls=mysql_query("SELECT callback_info FROM table WHERE callback_info !=''",$conn);
while($cust=mysql_fetch_array($calls)){
list($name,$time) = explode(",", $cust['callback_info']);
echo $name."<br>";
}
This gives me something like:
Snoop
Daz
Kurupt
Snoop
Snoop
I want to show the distinct name with the number of times it appeared like:
Snoop (3)
Daz (1)
Kurupt (1)
How would I go about doing this?
UPDATE this worked for me... $name needed to be put into an array
$calls=mysql_query("SELECT callback_info FROM table WHERE callback_info !=''",$conn);
$data = array();
while($cust=mysql_fetch_array($calls)){
list($name,$time) = explode(",", $cust['callback_info']);
$data[] = $emp;
}
$array = array_count_values($data);
for ($i = 0; $i < count($array); $i++) {
$name=key($array);
$number_calls=$array[$name];
if ($number_calls<> ' ') {
echo $name ." made ". $number_calls ." calls<br> ";
}
next($array);
}