[Resolved] Joining arrays on values?

[furious5]

Can anyone help me out.

Currently I have 1 array which looks like this:

Array ( [0] => Array ( [name] => Retief Goosen [groupno] => 5 [tee_off] => 0908+0100 )

And another array that looks like this:

Array ( [0] => 5 [1] => 1 [2] => 2 [3] => 3 [4] => 4 [5] => 6 [6] => 7 [7] => 8 ) 

Basically I want to join the two arrays on the groupno value in the first array, and the value contained in the second array. To create a final array which has the group no as the key and then an array of players for each event.

I've looked at array_combine but I'm running PHP4, so I can't use this.

Anyone any ideas??

[furious5]

Hmm I've managed to solve part of my problem, basically I can return a list of all the entrants I require, however I am now returning the array in this format:

Array ( [5] => Array ( [0] => Array ( [name] => Retief Goosen ) [1] => Array ( [tee_off_time] => 0908+0100 ) [2] => Array ( [name] => Jeff Maggert ) [3] => Array ( [tee_off_time] => 0908+0100 ) )

Instead I want to return it like so:

Array ( [5] => Array ( [0] => Array ( [name] => Retief Goosen [tee_off_time] => 0908+0100 ) [1] => Array ( [name] => Jeff Maggert [tee_off_time] => 0908+0100 ) )

Code now looks like this:

	while($row = mysql_fetch_assoc($sql_result)) {

	// Populate array with unique groups 
	if(in_array($row['groupno'], $grouping) == false) {
		$grouping[] = $row['groupno'];
	} 

	foreach($grouping as $item){

		if($row['groupno'] == $item){

			$group = $row['groupno'];
			$entrants[$group][]['name'] = $row['name'];
			$entrants[$group][]['tee_off_time'] = $row['tee_off_time'];
		}

	}

}