andrew92's php kode til wareye

<?php

$dbc = new mysqli("localhost", "root", "", "test");
$query = "SELECT * FROM `fisk`;";

if ($result = $dbc->query($query)) {
    while ($row = $result->fetch_assoc()) {
        $arr[] = array($row['K1'], $row['K2'], $row['K3']);
    }

    $result->close();
}

$workingK1 = NULL;
foreach ($arr as $index => $val) {
    if ( ($workingK1 == NULL) || ($workingK1 != $val[0]) ) {
        $workingK1 = $val[0];
        $newArr[$workingK1] = array(0 => NULL, 1 => NULL, 2 => NULL);
    }

    if ( ($newArr[$workingK1][2] == NULL) || ($arr[$index][2]) < ($newArr[$workingK1][2]) ) {
        $newArr[$workingK1][0] = $workingK1;
        $newArr[$workingK1][1] = $val[1];
        $newArr[$workingK1][2] = $val[2];
    }
}

// Arrayet $newArr inneholder nå en rad for hver unike K1,
// hvor K3 er lavest. Alle feltene (K1, K2 og K3) er i et subarray.
//
// Her looper jeg igjennom alle resultatene
echo '
    <table style="border: 1px #000 solid;">
        <tr>
            <td style="text-align: center;"><span style="font-weight: bold;">K1</span></td>
            <td style="text-align: center;"><span style="font-weight: bold;">K2</span></td>
            <td style="text-align: center;"><span style="font-weight: bold;">K3</span></td>
        </tr>
';
foreach ($newArr as $newIndex => $newVal) {
    echo '<tr>';

    foreach ($newArr[$newIndex] as $subIndex => $subVal) {
        echo '
            <td style="text-align: center;">' . $subVal . '</td>
        ';
    }
    echo '</tr>';
}
echo '</table>'

?>