[RESOLVED] counting how many times like numbers appear in arrays

tryingtolearn

I have an array that looks like this

Array
(
    [0] => 23
    [1] => 02
    [2] => 45
    [3] => 33
    [4] => 37
)
Array
(
    [0] => 01
    [1] => 08
    [2] => 20
    [3] => 21
    [4] => 27
)
Array
(
    [0] => 13
    [1] => 15
    [2] => 23
    [3] => 33
    [4] => 37
)
Array
(
    [0] => 01
    [1] => 08
    [2] => 20
    [3] => 21
    [4] => 27
)

Is it possible to count how many times the same number appears?
Like
#01 appeared XX times
#13 appeared XX times...
...#42 etc...

Thanks for any help to get me going in the right direction.

laserlight

You can use [man]array_count_values/man after merging the arrays.

tryingtolearn

I tried array_count_values but it gave me a count of 1 for every one
So merging sounds like it is the key but
can you explain "Merging the arrays"
Sorry
This is new to me.

tryingtolearn

Thanks for the reply
I tried array_count_values but ended up with a count of 1 for every #

It sounds like merging the arrays is the key but Im sorry
Im new and I dont understand,
Can you explain that part

Thanks

tryingtolearn

(Sorry if this is duplicated - I tried replying but it doesnt seem to post)
Thanks for the reply -
I tried
array_count_values but it just gave me a count of 1 for every number

Can you explain how I can merge the arrays?
That sounds like the key.
But Im new to this.
Sorry

tryingtolearn

How do you respond to messages?
I tried responding a few times and nothing posts
I will try again

(Sorry if this is duplicated - I tried replying but it doesnt seem to post)
Thanks for the reply -
I tried
array_count_values but it just gave me a count of 1 for every number

Can you explain how I can merge the arrays?
That sounds like the key.
But Im new to this.
Sorry

tryingtolearn

How do you respond?I just get a message saying this is a duplicate post???

tryingtolearn

(Sorry if this is duplicated - I tried replying but it doesnt seem to post)
Thanks for the reply -
I tried
array_count_values but it just gave me a count of 1 for every number

Can you explain how I can merge the arrays?
That sounds like the key.
But Im new to this.

laserlight

That was strange, the message filter decided that your innocent post was suspicious.

Well, it looks like you have 4 arrays. For array_count_values to work, you need to merge them, e.g., with array_merge(). As a demonstration of how array_count_values() works, here is an example with your arrays manually merged:

<?php
$array = array('23', '02', '45', '33', '37',
               '01', '08', '20', '21', '27',
               '13', '15', '23', '33', '37',
               '01', '08', '20', '21', '27');
print_r(array_count_values($array));
?>

tryingtolearn

Well I may need to start at the beginning

I have a database field with this number set
Ex.
01.23.42.55.47

So first I needed to break up those into individual #s
I did that by using this

$query = "SELECT num FROM bon";		
$result = @mysql_query ($query); // Run the query.
if ($result) {
   while ($row = mysql_fetch_assoc($result)){
   $listnum=$row['num'];
   $numarray = explode('.',$listnum);
   list($aa, $bb, $cc, $dd, $ee) = $numarray;	
   $combined = array($aa, $bb, $cc, $dd, $ee);


   echo '<pre>';
   print_r($combined);
   echo '</pre>';

	}
}

Once I did that I got the array listed above
So if I do the example you posted I still get a count of 1 for each #

So Im assuming I need to merge the

 list($aa, $bb, $cc, $dd, $ee) = $numarray;

From above but
Im really lost

laserlight

What exactly are you trying to do?

tryingtolearn

I need to find out how many times each number appears in the database
The problem is the way the numbers are added to the database,
(I have no control over that)
For example -
The database looks like this
ID number
1 02.07.11.23.34
2 11.16.23.52.73
3 03.11.52.73.99

etc...
The number field needs to be individual numbers seperated by the .
Then I need to count the results of the entire database listed like this

02 appears 1 time

03 appears 1 time

07 appears 1 time

11 appears 3 times

16 appears 1 time

23 appears 2 times

and so on...
So I can see how many times the number is present

Hope that makes sense

laserlight

(I have no control over that)

In that case, I would expect something along these lines:

$array = array();
while ($row = mysql_fetch_assoc($result)) {
    $array = array_merge($array, explode('.', $row['num']));
}
print_r(array_count_values($array));

tryingtolearn

Genius!!
Worked perfect,
I cant thank you enough!