PHP sort inside while

Question

I want the echo to be sorted by the value of $match_count. The highest number should be at the top.

while($row = mysql_fetch_array($result)) {
    $num_kanal = count(explode(' ', $row['kanaler']));

    $pr_kanal = $row['pris'] / $num_kanal;
    $pr_kanal = number_format((float)$pr_kanal, 2, '.', '');

    $farve = '#6a6a6a;';

    if ($_POST['kanaler']) {

        $getkan = implode($_POST['kanaler'], ' ');
        $kan = $row['kanaler'];
        $match_count = count(TheMatch($kan, $getkan));
        $match = ' Match = '.$match_count;
        }

        // I WANT THIS ECHO TO BE SORT BY THE VALUE OF '$match_count' HIGEST NR IN TOP //
        echo'<tr>
            <td style="background-color:'.$farve.'"><p>
            ' . $row['udbyder'] . ' '.$_POST['kanaler'].'
            </p></td>
    </tr>';
    }
}

Mario · Accepted Answer · 2012-12-05 21:33:04Z

1

You'd have to buffer your output/values while iterating over your array, sort it and then print it. Something like this:

$results = array();
while($row = ...) {
    ...
    $results[] = array($match_count, '<tr><td style="background-color:...</tr>');
}

uasort($results, my_comp);

foreach($results as $result)
    echo $result[1];

This will sort the array and then print it based on this sorting function:

function my_comp($left, $right) {
    return $left[0] > $right[0]; // to be honest I'm not 100% sure right now whether you'd need < or > for the right sorting order
}

answered Dec 5, 2012 at 21:33

Mario

36.7k5 gold badges70 silver badges87 bronze badges

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

Comments

randiel · Accepted Answer · 2012-12-05 22:51:39Z

0

You can use array_multisort too:

<?php 
array_multisort($match_count, SORT_DESC, $array_values_to_print);

foreach ($match_count as $result) {
    echo '<tr><td style="background-color:...</tr>';
}
?>

the first array determines the index.

answered Dec 5, 2012 at 22:51

randiel

2901 silver badge16 bronze badges

Collectives™ on Stack Overflow

PHP sort inside while

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related