need help with coding an array

[sso]

Hey guys,

I need help with coding an array, I just cannot wrap my head around it. I got the following array

 

$info =

Array (

[0] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 2 [EMPID] => 00675 [PCS] => 1060 [AMT] => 7.95 [PRICE] => 0.15 )

[1] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 3 [EMPID] => 00696 [PCS] => 980 [AMT] => 4.90 [PRICE] => 0.10 )

[2] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 5 [EMPID] => 00696 [PCS] => 1000 [AMT] => 5.00 [PRICE] => 0.10 )

[3] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 6 [EMPID] => 00675 [PCS] => 1060 [AMT] => 5.30 [PRICE] => 0.10 )

[4] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 7 [EMPID] => 00690 [PCS] => 1220 [AMT] => 4.88 [PRICE] => 0.08 )

[5] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00069 [PCS] => 300 [AMT] => 8.25 [PRICE] => 0.55 )

[6] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00336 [PCS] => 220 [AMT] => 6.05 [PRICE] => 0.55 )

[7] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00569 [PCS] => 240 [AMT] => 6.60 [PRICE] => 0.55 )

[8] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 8 [EMPID] => 00727 [PCS] => 300 [AMT] => 8.25 [PRICE] => 0.55 )

[9] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 9 [EMPID] => 00029 [PCS] => 1200 [AMT] => 8.40 [PRICE] => 0.14 )

[10] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 10 [EMPID] => 00092 [PCS] => 980 [AMT] => 6.86 [PRICE] => 0.14 )

[11] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 11 [EMPID] => 00059 [PCS] => 600 [AMT] => 6.00 [PRICE] => 0.20 )

[12] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 11 [EMPID] => 00704 [PCS] => 600 [AMT] => 6.00 [PRICE] => 0.20 )

[13] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 12 [EMPID] => 00356 [PCS] => 460 [AMT] => 2.76 [PRICE] => 0.12 )

[14] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 12 [EMPID] => 00716 [PCS] => 460 [AMT] => 2.76 [PRICE] => 0.12 )

[15] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00098 [PCS] => 360 [AMT] => 5.40 [PRICE] => 0.30 )

[16] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00341 [PCS] => 200 [AMT] => 3.00 [PRICE] => 0.30 )

17] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00465 [PCS] => 160 [AMT] => 2.40 [PRICE] => 0.30 )

[18] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00474 [PCS] => 80 [AMT] => 1.20 [PRICE] => 0.30 )

[19] => Array ( [AOCODE] => 3123121209-1 [OPTID] => 16 [EMPID] => 00473 [PCS] => 1080 [AMT] => 1.20 [PRICE] => 0.30 )

)

 

and I would like to use it to output the below array

 

$output =

Array (

[0] => Array ([OPTID] => 2 [EMPID1] => 00675 [PCS1] => 1060 [EMPID2] => [PCS2] =>)

[1] => Array ([OPTID] => 3 [EMPID1] => 00696 [PCS1] => 980 [EMPID2] => [PCS2] =>)

[2] => Array ([OPTID] => 5 [EMPID1] => 00696 [PCS1] => 1000 [EMPID2] => [PCS2] =>)

[3] => Array ([OPTID] => 6 [EMPID1] => 00675 [PCS1] => 1060 [EMPID2] => [PCS2] =>)

[4] => Array ([OPTID] => 7 [EMPID1] => 00690 [PCS1] => 1220 [EMPID2] => [PCS2] =>)

[5] => Array ([OPTID] => 8 [EMPID1] => 00069 [PCS1] => 300 [EMPID2] => 00336 [PCS2] => 220)

[6] => Array ([OPTID] => 8 [EMPID1] => 00569 [PCS1] => 240 [EMPID2] => 00727 [PCS2] =>300)

[7] => Array ([OPTID] => 9 [EMPID1] => 00029 [PCS1] => 1200 [EMPID2] => [PCS2] =>)

[8] => Array ([OPTID] => 10 [EMPID1] => 00092 [PCS1] => 980 [EMPID2] => [PCS2] =>)

[9] => Array ([OPTID] => 11 [EMPID1] => 00704 [PCS1] => 600 [EMPID2] => 00704 [PCS2] => 600)

[10] => Array ([OPTID] => 12 [EMPID1] => 00356 [PCS1] => 460 [EMPID2] => 00716 [PCS2] => 460)

[11] => Array ([OPTID] => 16 [EMPID1] => 00098 [PCS1] => 360 [EMPID2] => 00341 [PCS2] => 200)

[12] => Array ([OPTID] => 16 [EMPID1] => 00465 [PCS1] => 160 [EMPID2] => 00474 [PCS2] => 80)

[13] => Array ([OPTID] => 16 [EMPID1] => 00473 [PCS1] => 1080 [EMPID2] => [PCS2] =>)

 

)

 

I have been trying for the last couple of days to figure this out. Appreciate it if anyone could help to look at it.

 

 

Thanks

[teamatomic]

$output=array();
  $i=0;
foreach ($info as $input)
{
  $output[$i]['OPTID']=$input['OPTID'];
  $output[$i]['EMPID1']=$input['EMPID'];
  $output[$i]['PCS1']=$input['PCS'];
  $output[$i]['EMPID']='';
  $output[$i]['PCS2']='';

$i++;
}
print_r($output);

 

 

HTH

Teamatomic

[sso]

Thanks Teamomatic for the quick reply.

 

My problem is that with the first array there are some OPTIDs that have 1 or 2 or even 5 EMPIDs and I need to put them into sets of 2s into the new array. Do you think I need to run through the first array counting the number of EMPIDs first then somehow create the new array using the counted EMPIDs?

 

$output=array();
  $i=0;
foreach ($info as $input)
{
  $output[$i]['OPTID']=$input['OPTID'];
  $output[$i]['EMPID1']=$input['EMPID'];
  $output[$i]['PCS1']=$input['PCS'];
  $output[$i]['EMPID']='';
  $output[$i]['PCS2']='';

$i++;
}
print_r($output);

 

 

HTH

Teamatomic

[teamatomic]

Show me one of the inside arrays with multiple EMPIS. You did not show that in your original post, it would help if you were more explicit.

 

 

HTH

Teamatomic

[sso]

you see with the $output array

..

[2] => Array ([OPTID] => 5 [EMPID1] => 00696 [PCS1] => 1000 [EMPID2] => [PCS2] =>)

is different from

..

[11] => Array ([OPTID] => 16 [EMPID1] => 00098 [PCS1] => 360 [EMPID2] => 00341 [PCS2] => 200)

[12] => Array ([OPTID] => 16 [EMPID1] => 00465 [PCS1] => 160 [EMPID2] => 00474 [PCS2] => 80)

[13] => Array ([OPTID] => 16 [EMPID1] => 00473 [PCS1] => 1080 [EMPID2] => [PCS2] =>)

..

 

This depends on the $info because the number of times EMPID appears is not fixed so I need $output to be repeated depending on how many times EMPID appears? I am sorry if I am not clear.. I suspect there is a modulo in there somewhere.. what I got so far is counting the number of times EMPID corresponds with an OPTID and then hardcoding it in.. I am not sure if that is the most elegant way to do it..

 

Thanks for any further help you can give