help with multi-dimensional array

[agamemnon]

Let's say we have this multi-dimensional array:

   $array[0]['name'] = "John";
   $array[0]['money'] = "5";

   $array[1]['name'] = "Jack";
   $array[1]['money'] = "10";

   $array[2]['name'] = "John";
   $array[2]['money'] = "3";

Can someone please tell me how can I end up with this:

   $array[0]['name'] = "John";
   $array[0]['money'] = "8";

   $array[1]['name'] = "Jack";
   $array[1]['money'] = "10";

????????????
Thanx in advance😕

[altexis]

geia sou agamemnona 🙂 8a sta pw agglika mipws me simplirwsei/dior8wsei kanenas allos.

to change your 0 element just do this:
$array[0]['money'] = "8";

to remove the 2 element use:
unset($array[2]['name']);
unset($array[2]['money']);
unset($array[2]);

... i don't know if just " unset($array[2]); " would do the same.

just be carefull if you use $array[]='something' to re-enter new values
if you do so you would expect to have $array[2] but you will really get $array[3] !!!

[agamemnon]

Thanx altexis (tha sinehisoume sta agglika... :-) )
...but that won't do.

i need sth to do this automatically.

Check the array for duplicates in the first dimension,
Add the value of the second dim and
Delete the element that was added

[altexis]

hmm hmmmm

if you used to different arrays I have a helpful idea
say you have $arrayNames and $arrayMoney
they would contain exactly the same information

so maybe this would work:

reset($arrayNames);
while (list($key,$val)=each($arrayNames)) {
  $i=array_search($val, $arrayNames);
  if (is_numeric($i) && $i<$key) {
    $arrayMoney[$i]=$arrayMoney[$key];
    unset($arrayNames[$key]);
    unset($arrayMoney[$key]);
  }
}

[Weedpacket]

What I'm going to do first is change th format a bit. Instead of

$array = array(
	array( 'name' => 'John', 'money'=>5),
	array( 'name' => 'Jack', 'money'=>10),
	array( 'name' => 'John', 'money'=>3)
);

I'll have

$people = array(
	'John' => array(5, 3),
	'Jack' => array(10),
);

$people = array();
foreach($array as $name_and_money)
{	$name = $name_and_money['name'];
	$money = $name_and_money['money'];
	$people[$name][] = $money;
}

Now it's easy to add all the monies up for each person - replacing the array of monies with its sum:

foreach($people as $key=>$person)
{	$people[$key] = array_sum($person);
}

And then to convert back to the existing format

$array = array();
foreach($people as $name=>$money)
{	$array[] = array('name'=>$name, 'money'=>$money);
}

[agamemnon]

Thanks Weedpacket, but this won't do either. You see I can't change the format. It's data I get from elsewhere.
Anyway, I found a way to do it. I'm sure, it ain't the best way, but it works.
I list it below. (Any improvement would be very apreciated)

// this is the array
$array = array(
	array( 'name' => 'John', 'money'=>5),
	array( 'name' => 'Jack', 'money'=>10),
	array( 'name' => 'John', 'money'=>3)
);

// GET JUST NAMES
for ($i=0; $i<count($array); $i++) {
		$name_money[] = array("name"=>$array[$i]['name'],"money"=>$array[$i]['money']);
		$just_names[] = $array[$i]['name'];	// make another array with just the names
}


// GET UNIQUE NAMES
$just_names = array_unique(@$just_names);
$c=0;
for ($i=0; $i<=count($name_money); $i++) {
	if (@$just_names[$i]!='') {
		$unique_names[$c]	= $just_names[$i];	// make a new array with unique names indexed at 0
		$c++;
	}
}

// CHECK FOR DUPLICATES and ADD VALUES
for ($i=0; $i<count($unique_names); $i++) {	// check once every name
	for ($j=0; $j<count($name_money); $j++) {	 // with all moves
		if ($unique_names[$i]==$name_money[$j]['name']) {	// if you find him there (once is for sure)
			@$money_sum[$unique_names[$i]] += $name_money[$j]['money'];	// add the money he spent in an array
		}
	}
}

// FINALLY
foreach($money_sum as $key=>$value){
	$final_list[] = array('name'=>$key, 'money'=>$value);
}

print_r($final_list);

[Weedpacket]

You don't need to change the format at the source - once you've got it into your script you can do what you like with it, including making a new array in the other format (which is what the first block of code does). Note that the third block of code takes that other format and turns it into an array that looks exactly as if it had come from the source (and using the same format).

The intermediate format is merely a computational convenience. Smart data and dumb code is much easier to work with than the other way around: the second block of code is the one that's doing all the work.

[agamemnon]

...right, thanx a million Weedpacket.