How to sort the sum of columns in a delimited txt flat file?

[George Michael]

Hello!

I am stuck with this. Can anyone help me?

I have some rows in a text file. That I need: sum from selected columns and then sort the rows depending on the sum result and print the 10 larger sum results.

I have a part in this incomplete script that works but I cant put the array in this calculation. After this I try something else but there I need to sort the rows of it (depending on the sum of some columns that is being echoed.

Thanks in advance!!

data.txt is the txt that contains the records and here is the code of php:

 
<?php
 
function topTenDistricts($arr, $len) {
 
for ($i=0; $i < $len; $i++) {
    for ($j=0; $j < $len-1; $j++) {
        if ($arr[$j+1] > $arr[$j]) {
            $temp = $arr[$j];
            $arr[$j] = $arr[$j+1];
            $arr[$j+1] = $temp;
        }
    }
}
for ($k=0 ; $k < $len; $k++)
print($arr[$k] . "\n");
 
}
 
//// example of previous array sorting ->> topTenDistricts($mydata, 10);
//$mydata = array();
//$mydata[0] = 12;
//$mydata[1] = 4;
//$mydata[2] = 44;
//$mydata[3] = 3;
//$mydata[4] = 6;
//$mydata[5] = 32;
 
$max = 0;
$file = file("data.txt");
$r=0;
$sum=array();
foreach ($file as $line){
    list($row[$r]['partno'], $row[$r]['title'], $row[$r]['color'], $row[$r]['width'], $row[$r]['length'], $row[$r]['height'], $row[$r]['time'], $row[$r]['price'], $row[$r]['place']) = split(";", $line);
    $sum[r]=$row[$r]['color'] + $row[$r]['width'] + $row[$r]['length'] + $row[$r]['height'] + $row[$r]['time'] + $row[$r]['price'] + $row[$r]['place'];
    //echo 'Name DD. : '.$row[$r]['title'].' | Sum : '.$sum.'<br>';
    echo 'Name DD. :'.$row[$r]['title'].'with :'.$sum[r].' records<br>';
    $r++;
    if ($sum >= $max) {
                $max = $sum;
                $title = $row[$r]['title'];        
                }
    }