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        ))

<?php$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',  ),);$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  ";
              

你哪个字段有重复的啊？