數組是這樣的:
Array
(
[0] => Array
(
[CampaignID] => 2304111
[ExistStatus] => 2
[CampaignName] => 7月促銷中心
[CampaignType] => 定向推廣計劃
[AvgCommission] => 1.71 %
[Exist] => 1
[ShopKeeperID] => 18791530
[Properties] => 否
)
[1] => Array
(
[CampaignID] => 2979322
[CampaignName] => 新年 促銷價
[CampaignType] => 定向推廣計劃
[AvgCommission] => 4.90 %
[Exist] =>
[ShopKeeperID] => 18791530
[Properties] => 否
)
[2] => Array
(
[CampaignID] => 7275933
[CampaignName] => 感恩
[CampaignType] => 定向推廣計劃
[AvgCommission] => 1.53 %
[Exist] =>
[ShopKeeperID] => 18791530
[Properties] => 否
)
)
找出AvgCommission為最大值的,同時還要帶上CampaignID
讓結果顯示為array(2979322,4.9);
我演算法太差了,找了好多都看不明白!!!
回複討論(解決方案)
foreach($arr as $v) $r[] = $v['AvgCommission'];array_multisort($r, SORT_DESC, SORT_NUMERIC, $arr);$r = array($arr[0]['CampaignID'], $arr[0]['AvgCommission'] + 0);print_r($r);
你就是額的神
那也未必,這樣的程式碼群組合是定式,多接觸就熟練了
如果是資料庫查詢,那麼
SELECT CampaignID, AvgCommission FROM tbl_name ORDER BY AvgCommission DESC
你一定不陌生
其實他們是一一對應的
謝謝神,感覺明白了些了!