php多維陣列去重

php多維陣列去重，怎樣去掉name為a的多餘的那一個呢？
Array
(
[0] => Array
(
[id] => 79
[name] => a
)

[1] => Array
(

[id] => 79
[name] => a
)
[2] => Array
(
[id] => 78
[name] => b
)
[3] => Array
(

[id] => 36
[name] => c
)
)

回複討論(解決方案)

$ar = array (  0 =>   array (    'id' => '79',    'name' => 'a',  ),  1 =>   array (    'id' => '79',    'name' => 'a',  ),  2 =>   array (    'id' => '78',    'name' => 'b',  ),  3 =>   array (    'id' => '36',    'name' => 'c',  ),);foreach($ar as $k=>$f) {  foreach($ar as $p=>$t) if($k != $p && $f == $t) unset($ar[$k]);}print_r($ar);

Array(    [1] => Array        (            [id] => 79            [name] => a        )    [2] => Array        (            [id] => 78            [name] => b        )    [3] => Array        (            [id] => 36            [name] => c        ))

$arr=array(     0=>array(        'id'=>79,        'name'=>'a'         ),     1=>array(        'id'=>79,        'name'=>'a'      ),     2=>array(        'id'=>78,        'name'=>'b'     ),     3=>array(        'id'=>36,        'name'=>'c'     ),);$item=array();foreach($arr as $k=>$v){    if(!isset($item[$v['id']])) $item[$v['id']]=$v;}print_r(array_values($item));

Array(    [0] => Array        (            [id] => 79            [name] => a        )    [1] => Array        (            [id] => 78            [name] => b        )    [2] => Array        (            [id] => 36            [name] => c        ))

   array (    'id' => '79',    'name' => 'a',  ),  1 =>   array (    'id' => '79',    'name' => 'a',  ),  2 =>   array (    'id' => '78',    'name' => 'b',  ),  3 =>   array (    'id' => '36',    'name' => 'c',  ),);$temp =array();$result =array();foreach($ar as $item){$temp[] = json_encode($item);}$temp = array_unique($temp);foreach($temp as $item){$result[] = json_decode($item,true);}var_dump($result);

只是提供新思路 效率不高 勿用

array(3) {  [0]=>  array(2) {    ["id"]=>    string(2) "79"    ["name"]=>    string(1) "a"  }  [1]=>  array(2) {    ["id"]=>    string(2) "78"    ["name"]=>    string(1) "b"  }  [2]=>  array(2) {    ["id"]=>    string(2) "36"    ["name"]=>    string(1) "c"  }}

$ar = array (  0 =>   array (    'id' => '79',    'name' => 'a',  ),  1 =>   array (    'id' => '79',    'name' => 'a',  ),  2 =>   array (    'id' => '78',    'name' => 'b',  ),  3 =>   array (    'id' => '36',    'name' => 'c',  ),);foreach($ar as $k=>$f) {  foreach($ar as $p=>$t) if($k != $p && $f == $t) unset($ar[$k]);}print_r($ar);

Array(    [1] => Array        (            [id] => 79            [name] => a        )    [2] => Array        (            [id] => 78            [name] => b        )    [3] => Array        (            [id] => 36            [name] => c        ))

如果只是ID重複，name不重複怎麼去掉？

那你就有 #2 的代碼
不過嚴格的說這不是“去重”而是“聚類”
只不過是對同組資料只取一個，有點資料庫中 group 的味道

那你就有 #2 的代碼
不過嚴格的說這不是“去重”而是“聚類”
只不過是對同組資料只取一個，有點資料庫中 group 的味道

查詢的時候能直接把重複的過濾掉嗎？

SELECT DISTINCT(`id`) AS `id` , name FROM `TABLE`

SELECT DISTINCT(`id`) AS `id` , name FROM `TABLE`

這是我的SQL，我怎麼改都改不對，麻煩你幫我改改吧，謝謝了
$sql = "select t3.width as width, t3.height as height,t1.add_time as add_time,t1.add_author as add_author,t1.image_url as image_url,t1.id as id,t1.browse_real_cnt as browse_real_cnt from comments as t2 left join ornamentations as t1 on t1.id = t2.object_id left join ornamentation_images as t3 on t3.ornamentation_id = t1.id where ( t2.uid = $id ) AND ( t1.enable = '0' ) ORDER BY id desc LIMIT 0,5 ";

你哪個欄位有重複的啊？

