Sorting a 2d array

facets

Hi There,

Any ideas on how I could sort this $getTotalsArray 2d array?
The output looks like arrayID, clientID, total, and I wish to sort by total

function getDebtTop5($getTotalsArray) {

for ($row = 0; $row < count($getTotalsArray); $row++)
{
    for ($col = 0; $col < 2; $col++)
    {
        echo "<br>".$getTotalsArray[$row][$col];
    }
}
}

tia, Will

Installer

One way:

foreach ($getTotalsArray as $value) {
    $tmp[] = $value['total'];
}
array_multisort($tmp, SORT_ASC, $getTotalsArray);

facets

cheers! damn close.
that's sorting the client_id not the total.
need to sort one variable to the right.

Installer

What does "one variable to the right" mean? If you mean you want to sort by numeric key, then substitute the key in the proper place.

That code sorts by "total", which is what you said you wanted.

facets

hmm, maybe my explanation of my array is incorrect.
the output is certainly sorting by client id.
here's the output.

31
7955.43
32
8385.82
33
2987.22
34
7388.49
35
6235.27
37
21081.56
41
9334.96

So, the client id is 31 and total is 7955.43
Also, the array does not know anything about the title 'total'. Is that an issue?

Any other suggestions?

Installer

Well, you said "arrayID, clientID, total, and I wish to sort by total", so I assumed your array had associative indexes ("arrayID, clientID, total"). If not, then you'll need to substitute the appropriate numeric index in the code where I put 'total'. If the index for what was heretofore called "total" is 2, then use 2. The code I posted was meant to demonstrate multi-dimensional array sorting, not as drop-in code.