Unique Array by Value

Question

$email_users[] = $row;

print_r($email_users);

Result:

Array ( 

[0] => Array ( 
[user_id] => 87436 
[username] => Admin 
[user_email] => email@online.us 
[user_lang] => de 
[allowed] => 1 ) 

[1] => Array ( 
[user_id] => 68013 
[username] => Testuser 
[user_email] => email2@online.us 
[user_lang] => de 
[allowed] => 1 ) 

[2] => Array ( 
[user_id] => 68013 
[username] => Testuser 
[user_email] => email2@online.us 
[user_lang] => de 
[allowed] => 1 ) 

)

As you can see, the user_id 68013 is double. I have to remove the double Array. The Result should look like this:

Array ( 

[0] => Array ( 
[user_id] => 87436 
[username] => Admin 
[user_email] => email@online.us 
[user_lang] => de 
[allowed] => 1 ) 

[1] => Array ( 
[user_id] => 68013 
[username] => Testuser 
[user_email] => email2@online.us 
[user_lang] => de 
[allowed] => 1 ) 

)

I read and tried several solutions I found on stack. For example:

How to get unique value in multidimensional array

$email_users[] = $row;

$user_ids = array();
foreach ($email_users as $h) {
$user_ids[] = $h['user_id'];
}
$email_users = array_unique($user_ids);

print_r($email_users);

But the print_r is only:

Array ( [0] => 87436 [1] => 68013 )

Thanks for your time.

I guess you get your data from a SQL-query - could you post that query, and have you tried SELECT DISTINCT ? — Franz Gleichmann, Nov 20 '15 at 10:53
@FranzGleichmann Select Distinct want work because its a loop. Thank you — labu77, Nov 20 '15 at 11:02
Simply use `print_r(array_unique($email_users,SORT_REGULAR));` From where you were getting this array — Narendrasingh Sisodia, Nov 20 '15 at 11:03
@Uchiha like a charm. I will accept the answer from Bharat, its the same but I have no accept button for your comment. — labu77, Nov 20 '15 at 11:06
Possible duplicate of [How to remove duplicate values from a multi-dimensional array in PHP](http://stackoverflow.com/questions/307674/how-to-remove-duplicate-values-from-a-multi-dimensional-array-in-php) — Narendrasingh Sisodia, Nov 20 '15 at 11:14

score 0 · Accepted Answer · answered Nov 20 '15 at 10:57

0

You should get distinct value from your query. Use SELECT DISTINCT * FROM tablename and you will get Distinct value. Or use $email_users= array_unique($email_users, SORT_REGULAR);

answered Nov 20 '15 at 10:57

Bharat Paudyal

124
1
10

Distinct want work, because its a loop but your SORT_REGULAR is fine :) thank you – labu77 Nov 20 '15 at 11:07

Unique Array by Value

1 Answers1