CODEWITHSUNDEEP
php
PhpDude
PhpDude

Reputation: 1598

Find lowest value in results set

I am trying to find the cleanest method of turning this set of results into an array and then finding the lowest value.

if (!$result) die($conn->error);
while($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) 
{
    $low_score_1 = $row['low_score_1'];
    $low_score_2 = $row['low_score_2'];
    $low_score_3 = $row['low_score_3'];
    $low_score_4 = $row['low_score_4'];
    $low_score_5 = $row['low_score_5'];
    $low_score_6 = $row['low_score_6'];
    $low_score_7 = $row['low_score_7'];
    $low_score_8 = $row['low_score_8'];  

}

Upvotes: 0

Views: 36

Answers (1)

RiggsFolly
RiggsFolly

Reputation: 94642

This should do what you want. Its a bit simple and long hand but sometimes thats easier

if (!$result) die($conn->error);

// read first row and seed the variables with these values
$row=mysqli_fetch_array($result, MYSQLI_ASSOC);
$low_score_1 = $row['low_score_1'];
$low_score_2 = $row['low_score_2'];
$low_score_3 = $row['low_score_3'];
$low_score_4 = $row['low_score_4'];
$low_score_5 = $row['low_score_5'];
$low_score_6 = $row['low_score_6'];
$low_score_7 = $row['low_score_7'];
$low_score_8 = $row['low_score_8']; 

while($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) 
{
    $low_score_1 = ($row['low_score_1'] < $low_score_1) ? $row['low_score_1'] : $low_score_1;
    $low_score_2 = ($row['low_score_2'] < $low_score_2) ? $row['low_score_2'] : $low_score_2;
    $low_score_3 = ($row['low_score_3'] < $low_score_3) ? $row['low_score_3'] : $low_score_3;
    $low_score_4 = ($row['low_score_4'] < $low_score_4) ? $row['low_score_4'] : $low_score_4;
    $low_score_5 = ($row['low_score_5'] < $low_score_5) ? $row['low_score_5'] : $low_score_5;
    $low_score_6 = ($row['low_score_6'] < $low_score_6) ? $row['low_score_6'] : $low_score_6;
    $low_score_7 = ($row['low_score_7'] < $low_score_7) ? $row['low_score_7'] : $low_score_7;
    $low_score_8 = ($row['low_score_8'] < $low_score_8) ? $row['low_score_8'] : $low_score_8;

}

// lowest of the entire set
$t = array($low_score_1,$low_score_2,$low_score_3,$low_score_4,
            $low_score_5,$low_score_6,$low_score_7,$low_score_8)

echo min($t);

Or you could do

while($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    $low1[] = $row['low_score_1'];
    $low2[] = $row['low_score_2'];
    $low3[] = $row['low_score_3'];
    $low4[] = $row['low_score_4'];
    $low5[] = $row['low_score_5'];
    $low6[] = $row['low_score_6'];
    $low7[] = $row['low_score_7'];
    $low8[] = $row['low_score_8'];  
}

$low_score_1 = min($low1);
$low_score_2 = min($low2);
$low_score_3 = min($low3);
$low_score_4 = min($low4);
$low_score_5 = min($low5);
$low_score_6 = min($low6);
$low_score_7 = min($low7);
$low_score_8 = min($low8);

// lowest of the entire set
$t = array($low_score_1,$low_score_2,$low_score_3,$low_score_4,
            $low_score_5,$low_score_6,$low_score_7,$low_score_8);

echo min($t);

Upvotes: 1

Related Questions