[Resolved] Need help group elements in an array

[EricC]

This should be fairy straightfoward but after starring blankly at my monitor long enough, I decided to come here and ask(beg) for help. 🙂

Here is a small sample of the array that is similar to the one I'm working with for reference..

Array
(
    [0] => Array
        (
            [ID] => 102799
            [CreatedTime] => Jul 8 2004  4:10PM
            [ModifiedUserID] => 86
            [RevisionNumber] => 0
            [ChangeNumber] => 102763
            [Severity] => 100
        )
    [1] => Array
        (
            [ID] => 102762
            [CreatedTime] => Jul 8 2004  6:11PM
            [ModifiedUserID] => 24
            [RevisionNumber] => 1
            [ChangeNumber] => 102763
            [Severity] => 100
        )
    [2] => Array
        (
            [ID] => 102718
            [CreatedTime] => Jul 9 2004  8:03AM
            [ModifiedUserID] => 11
            [RevisionNumber] => 3
            [ChangeNumber] => 102763
            [Severity] => 100
        )
    [3] => Array
        (
            [ID] => 102611
            [CreatedTime] => Jun 18 2004  2:23PM
            [ModifiedUserID] => 17
            [RevisionNumber] => 0
            [ChangeNumber] => 102612
            [Severity] => 100
        )
    [4] => Array
        (
            [ID] => 102510
            [CreatedTime] => Jun 7 2004  10:43AM
            [ModifiedUserID] => 24
            [RevisionNumber] => 0
            [ChangeNumber] => 102511
            [Severity] => 100
        )
)

What I would like to be able to do is to loop through this array and "pull" out similar entries that have the same ChangeNumber so that I could loop through those like numbered ChangeNumber entries outside of the larger array. In this example I have 3 unique ChangeNumbers so I would want to break the larger array into 3 smaller arrays and loop across each of those separately. Since the array I'm working with is a result set from a database, the number of entries in it is never the same, the only field being constant is the ChangeNumber.

Any advice would be greatly appreciated. I'm not sure if I've made it clear what I'm trying to do here since I'm not exactly sure what I'm trying to do in the first place. 😉

Thanks in advance. 🙂

[bubblenut]

Well I would suggest keeping it all in one array but extending the depth by one level. If that doesn't make sense don't worry, I'm nt even sure if I've used the right terminollogy so I'll just show you what I mean.

<?php
//an array structured like the one in your example
$start_array; 
//where your final result will go
$end_array=array();
//count the array before hand so it doesn't have 
//to be calculated on every iteration
$start_array_c = count($start_array);
//loop the start array
for($i=0; $i < $start_array_c; $i++) {
  //place append this element in start array in the element 
  //which is named the same as the ChangeNumber of
  //this element, create it if it doesn't exist
  $end_array[$start_array[$i]['ChangeNumber']][] = $start_array[$i];
}
?>

For the example you gave $end_array would look <voice style="Elvis"> a little something like this</voice>

Array
(
	[102763] => Array
	(
		[0] => Array
		(
            [ID] => 102799
            [CreatedTime] => Jul 8 2004  4:10PM
            [ModifiedUserID] => 86
            [RevisionNumber] => 0
            [ChangeNumber] => 102763
            [Severity] => 100
		)
		[1] => Array
		(
            [ID] => 102762
            [CreatedTime] => Jul 8 2004  6:11PM
            [ModifiedUserID] => 24
            [RevisionNumber] => 1
            [ChangeNumber] => 102763
            [Severity] => 100
		)
		[2] => Array
		(

        [ID] => 102718
        [CreatedTime] => Jul 9 2004  8:03AM
        [ModifiedUserID] => 11
        [RevisionNumber] => 3
        [ChangeNumber] => 102763
        [Severity] => 100
	)
)
[102612] => Array
(
	[0] => Array
	(
        [ID] => 102611
        [CreatedTime] => Jun 18 2004  2:23PM
        [ModifiedUserID] => 17
        [RevisionNumber] => 0
        [ChangeNumber] => 102612
        [Severity] => 100
	)
)
[102511] => Array
(
	[0] => Array
	(
        [ID] => 102510
        [CreatedTime] => Jun 7 2004  10:43AM
        [ModifiedUserID] => 24
        [RevisionNumber] => 0
        [ChangeNumber] => 102511
        [Severity] => 100
	)
)
)

HTH
Bubble

[EricC]

Originally posted by bubblenut
HTH
Bubble [/B]

That's given me a really good idea on how to tackle this issue. I appreciate the advice! 🙂

[bubblenut]

Let us know how you did it when you do 🙂

[devinemke]

what about this?

$result = mysql_query('SELECT * FROM table ORDER BY ChangeNumber');
while ($row = mysql_fetch_assoc($result)) {$array[$row['ChangeNumber']][] = $row;}
print_r($array);

[bubblenut]

Originally posted by devinemke
what about this?

$result = mysql_query('SELECT * FROM table ORDER BY ChangeNumber');
while ($row = mysql_fetch_assoc($result)) {$array[$row['ChangeNumber']][] = $row;}
print_r($array);

[/B]

Good call, good call indeed. I'd missed the point that it was from a database.