如何从PDO数组结果中删除重复数据 [英] HOw remove Duplicate data from Array result of PDO

问题描述

我在array中获取PDO查询结果.查询是动态变化的.因此，不要写答案来更改查询.查询结果是固定的. Print_r显示以下结果.

i am getting PDO Query result in array . Query is changes dynamically. So don't write answer to change query. Query result is Fixed. Print_r display following result.

              while($r = $q->fetch()) 

$ r上有哪些商店

  [number]       => 001 
  [code]        => 387
  [ACCOUNTTYPE]      => 60 

 [number] => 001 
 [code] => 387 
 [ACCOUNTTYPE] => 61 

 [number] => 002 
 [code] => 388
 [ACCOUNTTYPE] => 67 

 [number] => 002
 [code] => 388
 [ACCOUNTTYPE] => 65 

现在显示.

 001  | 387  | 60 |
 001  | 387  | 61 |
 002  | 388  | 67 |
 002  | 388  | 65 |

我要删除重复项并输入黑色数据.

I want To Remove Duplicate entry and enter black data.

我想要这样的数组或打印成这样的形式显示在php表中

i want array like this or print to display in php table like this

 001  | 387  | 60 |
      |      | 61 |
 002  | 388  | 67 |
             | 65 |

那么我该怎么做.那么我如何将其分组.有时组"列会更多.

So how can i do this. So how i can Group this . Some times Group columns are more.

$ groupcolunmsarray 包括要分组的列. 现在，它的一致性值 number 和 code

$groupcolunmsarray consist which columns want to group. Now its consisit value number and code

  $groupcolunmsarray[0]=number
  $groupcolunmsarray[1]=code

如何使用$ groupcolunmsarray和$ r像这样的结构来分组和删除重复项或订单.

using $groupcolunmsarray and $r how can i group and remove duplicate or order by like this Structure.

 001  | 387  | 60 |
      |      | 61 |
 002  | 388  | 67 |
             | 65 |

推荐答案

数据不足，因此不可能&请详细写plz. 使用For循环和if条件删除重复数据.

it is insufficient data so its impossible & write in detail plz. Use For loop and if condition to Remove repetitive data.

这篇关于如何从PDO数组结果中删除重复数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！