Help with arrays

[way2real]

I have following in a csv file:

sku,quantity,price

ML2225-1/4,10,38.77
ML2225-1/4,20,36
ML2225-1/4,30,33.23
ML2225-5/16,10,35.94
ML2225-5/16,20,33.37
ML2225-5/16,30,30.8
ML2225-3/8,10,34.37
ML2225-3/8,20,31.92
ML2225-3/8,30,29.46
ML2225-7/16,10,34.37
ML2225-7/16,20,31.92
ML2225-7/16,30,29.46
ML2225-1/2,10,34.37
ML2225-1/2,20,31.92
ML2225-1/2,30,29.46
...

I am able to read the file (fgetcsv). How do I build an array for each unique sku set, then do something, then continue to the next unique sku set?

To explain further, using the csv file above, the below is what I would like to accomplish:

<?php
$sku = 'ML2225-1/4';
$tierPrices = array();

//first tier price
$tierPrices[] = array(
    'qty' => 10,
    'price' => 38.77
); 

//second tier price
$tierPrices[] = array(
    'qty' => 20,
    'price' => 36.00
); 

//third tier price
$tierPrices[] = array(
    'qty' => 30,
    'price' => 33.23
); 

// save the tier prices
$proxy->call('tierprice.update', array('ML2225-1/4', $tierPrices)); 

//LOOP THROUGH THE LIST TO PROCESS EACH UNIQUE SKU
//ML2225-5/16 WOULD BE NEXT, THEN
//ML2225-3/8, ETC.

?>

I appreciate any thoughts.

Thanks,
Mike S

[ixalmida]

Try building your array like this:

$fh = fopen("filename.csv");
while($data = fgetcsv($fh))
  {
  $sku = $data[0];
  $tierPrices[$sku]['qty'] = $data[1];
  $tierPrices[$sku]['price'] = $data[2];
  }

You can either do your operations in the above loop, or loop through the array later like this:

foreach($tierPrices as $sku => $field)
  {
  $qty = $field['qty'];
  $price = $field['price'];
  }