Getting MIN value from array based on another value

Question

Whats the best way to get each of the "Carrier"'s lowest rate?

Array
(
    [0] => Array
        (
            [Method] => SMART_POST
            [Title] => Smart Post
            [Price] => 8.58
            [Carrier] => fedex
            [Carrier Title] => Fedex
            [Description] =>
        )

    [1] => Array
        (
            [Method] => GROUND_HOME_DELIVERY
            [Title] => Home Delivery
            [Price] => 12.34
            [Carrier] => fedex
            [Carrier Title] => Fedex
            [Description] =>
        )

    [2] => Array
        (
            [Method] => FEDEX_EXPRESS_SAVER
            [Title] => Express Saver
            [Price] => 16.25
            [Carrier] => fedex
            [Carrier Title] => Fedex
            [Description] =>
        )

    [3] => Array
        (
            [Method] => FEDEX_2_DAY
            [Title] => 2 Day
            [Price] => 20.49
            [Carrier] => fedex
            [Carrier Title] => Fedex
            [Description] =>
        )

    [4] => Array
        (
            [Method] => PRIORITY_OVERNIGHT
            [Title] => Priority Overnight
            [Price] => 32.17
            [Carrier] => fedex
            [Carrier Title] => Fedex
            [Description] =>
        )

    [5] => Array
        (
            [Method] => 4
            [Title] => Standard Post
            [Price] => 8.76
            [Carrier] => usps
            [Carrier Title] => United States Postal Service
            [Description] =>
        )

    [6] => Array
        (
            [Method] => 1
            [Title] => Priority Mail 3-Day
            [Price] => 10.25
            [Carrier] => usps
            [Carrier Title] => United States Postal Service
            [Description] =>
        )

    [7] => Array
        (
            [Method] => 3
            [Title] => Priority Mail Express 2-Day
            [Price] => 38.8
            [Carrier] => usps
            [Carrier Title] => United States Postal Service
            [Description] =>
        )

)

With the above array the result would be

fedex Smart Post 8.58 usps Standard Post 8.76

I have some working code, it's just horribly inefficient and hard to debug, I'm asking for the best option. — Brad
– Brad, Commented Jul 16, 2014 at 4:28
I didn't understand your requirement. You told you need the "lowest" rate. The "lowest" rate is only one value, but you are telling in the explanation for 2 values. Am I missing something? — late_riser
– late_riser, Commented Jul 16, 2014 at 4:31

웃웃웃웃웃 · Accepted Answer · 2014-07-16 04:27:02Z

1

Try this

$arr = Array
(
    0 => Array
        (
            'Method' => 'SMART_POST',
            'Title' => 'Smart Post',
            'Price' => '8.58',
            'Carrier' => 'fedex',
            'Carrier Title' => 'Fedex',
            'Description' =>''
        ),

    1 => Array
        (
            'Method' => 'GROUND_HOME_DELIVERY',
            'Title' => 'Home Delivery',
            'Price' => '12.34',
            'Carrier' => 'fedex',
            'Carrier Title' => 'Fedex',
            'Description' =>''
        ),

    2 => Array
        (
            'Method' => 'FEDEX_EXPRESS_SAVER',
            'Title' => 'Express Saver',
            'Price' => '16.25',
            'Carrier' => 'fedex',
            'Carrier Title' => 'Fedex',
            'Description' =>''
        ),

    3 => Array
        (
            'Method' => 'FEDEX_2_DAY',
            'Title' => '2 Day',
            'Price' => '20.49',
            'Carrier' => 'fedex',
            'Carrier Title' => 'Fedex',
            'Description' =>''
        ),

    4 => Array
        (
            'Method' => 'PRIORITY_OVERNIGHT',
            'Title' => 'Priority Overnight',
            'Price' => '32.17',
            'Carrier' => 'fedex',
            'Carrier Title' => 'Fedex',
            'Description' =>''
        ),

    5 => Array
        (
            'Method' => 4,
            'Title' => 'Standard Post',
            'Price' => '8.76',
            'Carrier' => 'usps',
            'Carrier Title' => 'United States Postal Service',
            'Description' =>''
        ),

    6 => Array
        (
            'Method' => 1,
            'Title' => 'Priority Mail 3-Day',
            'Price' => '10.25',
            'Carrier' => 'usps',
            'Carrier Title' => 'United States Postal Service',
            'Description' =>''
        ),

    7 => Array
        (
            'Method' => 3,
            'Title' => 'Priority Mail Express 2-Day',
            'Price' => '38.8',
            'Carrier' => 'usps',
            'Carrier Title' => 'United States Postal Service',
            'Description' =>''
        )

);
usort($arr, function($a, $b) {
    return $a['Price'] - $b['Price'];
});
print_r($arr);

answered Jul 16, 2014 at 4:27

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Brad Over a year ago

A good start, but only does the lowest. I need the lowest of each. I guess I could make two arrays from the data based off the carrier.

Brad Over a year ago

function sortr($a, $b) { return $a['Price'] - $b["Price"]; } usort($rates, "sortr"); $fst = array_shift($rates); while ($fst['Carrier']==$rates[0]['Carrier']){ array_shift($rates); }

Collectives™ on Stack Overflow

Getting MIN value from array based on another value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related