How to remove duplicate keys in array

Question

I have an array called $myarray -

id position status name

4    23        4   john

3    45        3   mike

4    23        0   john

7    25        2   sam

etc.

i need to filter array by "id" and when similar records found i need to evaluate by "status"key to remove number that's 0 or less than "status" in matching row. Is there some way to do it fast like some function?

I'm confused about your array structure. If I wanted mike's name, would I look at $myarray[1]['name'] (row #1) or $myarray[3]['name'] (id=3) — Robert Martin
– Robert Martin, Commented Sep 26, 2011 at 5:12
Note: There are no duplicate keys in PHP arrays. Only duplicate values. Just as this question is a duplicate of many others: stackoverflow.com/questions/5960190/… — thwd
– thwd, Commented Sep 26, 2011 at 5:13

Rusty Fausak · Accepted Answer · 2011-09-26 05:11:23Z

1

You could use array_multisort(..) to sort by id ASC then status DESC. Then you could walk through the sorted array and delete rows where the id has been seen before.

answered Sep 26, 2011 at 5:11

Rusty Fausak

7,5641 gold badge30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rabudde · Accepted Answer · 2011-09-26 05:11:55Z

0

This removes all occurences of status=0. If u want to keep these rows, when there is no other matching id, remove the $value['status'] > 0 &&

$cleanarray = array();
foreach ($myarray as $value) {
    if (
        $value['status'] > 0 && (
            !array_key_exists($value['id'], $cleanarray) ||
            $value['status'] > $cleanarray[$value['id']]['status']
        )
    ) $new_cleanarray[$value['id']] = $value;
}

answered Sep 26, 2011 at 5:11

rabudde

7,7826 gold badges58 silver badges95 bronze badges

Comments

user909058 · Accepted Answer · 2011-09-26 05:12:56Z

0

array_filter()

This might be of your use

answered Sep 26, 2011 at 5:12

user909058

1881 gold badge2 silver badges11 bronze badges

2 Comments

Rusty Fausak Over a year ago

array_filter doesn't compare two elements in an array.. It only looks at one.

Rusty Fausak Over a year ago

The callback function is only passed one element of the array.

Collectives™ on Stack Overflow

How to remove duplicate keys in array

3 Answers 3

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Linked

Related