way2real

Perfect. Thank you Sasa. I really appreciate the help.

Thank you Sasa. I appreciate the quick response. Maybe I should have included more information. I am having a tough time wrapping my head around this and how to get it to work for what I have in mind. Using the csv file from the earlier post, 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.

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? Thanks, Mike

Disregard. Seem the upgrade broke a couple of tables.

MySQL version: 4.1.22 SELECT groups.description AS groupdescription, directory, image_id FROM (events INNER JOIN images ON events.event_id = images.event_id) INNER JOIN groups ON events.group_id = groups.group_id WHERE events.group_id = "Group1" MySQL said: Documentation #1017 - Can't find file: 'events' (errno: 2) Can someone help me correct the problem? Thank you.