[RESOLVED] Help finding lowest number in array.

[fotofx]

I have the following array. I need to figure out which sub-array has the lowest score (taking negative numbers into account) and create two strings. The first string would be the name of the sub array (5002, 6501, 136, etc) and the second string would be the low score.

In this array the strings should be:

$name = "262;
$score = -50;

Here is the array..

Array
(
    [5002] => Array
        (
            [live] => 69
            [avg_age] => 11.9710
            [logged_in] => 50
            [level] => 100
            [score] => -37.339
        )

[6501] => Array
    (
        [live] => 57
        [avg_age] => 23.0351
        [logged_in] => 50
        [level] => 100
        [score] => -26.3949
    )

[122] => Array
    (
        [live] => 34
        [avg_age] => 14.0588
        [logged_in] => 50
        [level] => 100
        [score] => -35.6012
    )

[136] => Array
    (
        [live] => 111
        [level] => 100
        [avg_age] => 40.3243
        [score] => 41.4343
    )

[150] => Array
    (
        [live] => 1
        [avg_age] => 1.0000
        [level] => 100
        [score] => 1.01
    )

[262] => Array
    (
        [logged_in] => 50
        [live] => 0
        [level] => 100
        [score] => -50
    )

[325] => Array
    (
        [live] => 148
        [avg_age] => 30.0676
        [level] => 100
        [score] => 31.5476
    )

[388] => Array
    (
        [live] => 75
        [avg_age] => 12.8133
        [logged_in] => 50
        [level] => 100
        [score] => -36.4367
    )

[409] => Array
    (
        [live] => 52
        [avg_age] => 20.2115
        [logged_in] => 50
        [level] => 100
        [score] => -29.2685
    )

[423] => Array
    (
        [live] => 17
        [avg_age] => 7.4706
        [logged_in] => 50
        [level] => 100
        [score] => -42.3594
    )

[437] => Array
    (
        [live] => 22
        [avg_age] => 4.4091
        [logged_in] => 50
        [level] => 100
        [score] => -45.3709
    )

[444] => Array
    (
        [live] => 5
        [avg_age] => 6.2000
        [level] => 100
        [score] => 6.25
    )

[451] => Array
    (
        [live] => 22
        [avg_age] => 8.8182
        [logged_in] => 50
        [level] => 100
        [score] => -40.9618
    )

[458] => Array
    (
        [live] => 0
        [level] => 100
        [score] => 0
    )

[465] => Array
    (
        [live] => 6
        [avg_age] => 4.3333
        [level] => 100
        [score] => 4.3933
    )

)

[dagon]

someone will suggest something more elegant, but this is functional.

foreach($array as $k){
$new[$k]=$k[score];
}
asort($new)

;

[fotofx]

Hmmm... Can't get it to work..

The above array is called $newarray

Here is what I have:

foreach($newarray as $k){
$new[$k]=$k[score];
}
asort($new);

[fotofx]

Also, reading the docs for asort I am not sure it would accomplish what I need. I want to extract the name and score of the subarray that has the lowest score.

[dagon]

after a little more thought:

<?php

$a = array(
	'zzz'=>array(
	'score'=>'4'),'5002'=>array(
	'score'=>'-37.339'),'6501'=>array(
	'score'=>'-26.3949'));

print_r($a);

uasort($a,"custom_sort");
function custom_sort($a,$b){
	return $a['score']>$b['score'];
}

print_r($a);

echo key($a).' '.$a[key($a)]['score'];
?>

[fotofx]

Now I am really confused... The array posted above is called $newarray

I tried your code on $newarray instead of using the array you are creating and it does not work???

Here is what I have:

uasort($newarray,"custom_sort");
function custom_sort($a,$b){
return $a['score']>$b['score'];
}

print_r($a);

echo key($a).' '.$a[key($a)]['score'];

[cahva]

I quess the first one was more clear but had an error(no key->value in foreach):

foreach($newarray as $k => $v){
    $new[$k]=$v['score'];
}
asort($new);

// Gets the first element's key and value of the array
$name = key($new);
$score = current($new);

[fotofx]

Bingo.... That ones the winner.. Worked Great..

Thanks

[dagon]

uasort would be faster, no need to create a new array, you failed to replace $a with $newarray as needed:

$newarray = array(
	'zzz'=>array(
	'score'=>'4'),'5002'=>array(
	'score'=>'-37.339'),'6501'=>array(
	'score'=>'-26.3949'));

uasort($newarray,"custom_sort");
function custom_sort($a,$b){
return $a['score']>$b['score'];
}

print_r($newarray);

echo key($newarray).' '.$newarray[key($newarray)]['score'];

[fotofx]

Thanks, I will give it a shot.. Speed is really not an issue. This routine only runs about 50 times a day.

[dagon]

just a thought, if its from a db, then sort it that way.

[cahva]

dagon;10989106 wrote:

just a thought, if its from a db, then sort it that way.

Heh, if its from db, sort it in db-level 😉