[RESOLVED] unique array count

chrisleon

Yesterday I asked how to get unique values from an array. I got a suggestion for array_unique and it worked great. Now I am trying to count how many times each unique value did show up. ie.

LAMB WESTON INC 15
ADVANCE FOOD COMPANY 3
TYSON FOODS, INC. 12

etc......

I am using array_count_values, but I cannot get both to show up that way, I get output like this:

LAMB WESTON INC 2
LAMB WESTON INC 1
LAMB WESTON INC 17
LAMB WESTON INC 71
LAMB WESTON INC 2
LAMB WESTON INC 16
LAMB WESTON INC 6
LAMB WESTON INC 2
ADVANCE FOOD COMPANY 2
ADVANCE FOOD COMPANY 1
ADVANCE FOOD COMPANY 17
ADVANCE FOOD COMPANY 71
ADVANCE FOOD COMPANY 2
ADVANCE FOOD COMPANY 16
ADVANCE FOOD COMPANY 6
ADVANCE FOOD COMPANY 2
TYSON FOODS, INC. 2
TYSON FOODS, INC. 1
TYSON FOODS, INC. 17
TYSON FOODS, INC. 71
TYSON FOODS, INC. 2
TYSON FOODS, INC. 16
TYSON FOODS, INC. 6
TYSON FOODS, INC. 2

I am struggling getting the two to come together. I am getting what I need, now I need to structure it correctly.

laserlight

Try [man]array_count_values/man

chrisleon

I am using array_count_values, and that is why it is showing the name of the customer plus the value, but it is replicated for as many times as it shows up.

laserlight

Any example code and sample data?

Piranha

I have no idea if this is at all relevant to your problem or not, but to me it seems like you fetch the result from a database. If that is the case it is faster to let the database count instead of letting PHP do it, the database is much faster.

chrisleon

I used this to make it work, sorry for my ignorance:

$vendortypes = array_unique($vendortype);
$vendorcount = array_count_values($vendortype);

foreach ($vendortypes as $value){
$c = $vendorcount[$value];
print "<div class=blacktext align=center>$value $c</div>";
}

laserlight

Try this instead:

$vendor_count = array_count_values($vendortype);

foreach ($vendor_count as $vendor => $count) {
    echo '<div class="blacktext" align="center">' . $vendor . ' ' . $count . '</div>';
}

chrisleon

I know its fixed, but that code you just re-wrote worked great, but I am wondering why there is even an array_unique function if you can achieve the same result with what you gave me? I have a lot to learn about arrays.

Thank you

laserlight

Well, array_unique() is likely to be more efficient than array_count_values() if you are only interested in finding the distinct elements of the array, and not in the frequency of each distinct element.