kan met MIN() 0 niet uitfilteren
De testwaarden zijn; 65, 33, 6, 0
Als de 0 niet voorkomt doet de functie het prima, met nul erbij laat ie 0 als minimum zien. Dat wil ik niet.
Ik zoek de laagste waarde excl. 0
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<?
function get_min_surface($advertise_number)
{
$query_min = "SELECT DISTINCT
MIN(rm_1_life_surface_in_m) AS rm_1_life_surface_in_m,
MIN(rm_2_life_surface_in_m) AS rm_2_life_surface_in_m,
MIN(rm_3_life_surface_in_m) AS rm_3_life_surface_in_m,
MIN(rm_4_life_surface_in_m) AS rm_4_life_surface_in_m
FROM `vacation_occupancy`
WHERE advertise_number = '$advertise_number';";
$result_min = mysql_query($query_min) or die(mysql_error());
while ($line_min = mysql_fetch_array($result_min))
{
$min_surface = min($line_min);
return $min_surface;
}
}
?>
function get_min_surface($advertise_number)
{
$query_min = "SELECT DISTINCT
MIN(rm_1_life_surface_in_m) AS rm_1_life_surface_in_m,
MIN(rm_2_life_surface_in_m) AS rm_2_life_surface_in_m,
MIN(rm_3_life_surface_in_m) AS rm_3_life_surface_in_m,
MIN(rm_4_life_surface_in_m) AS rm_4_life_surface_in_m
FROM `vacation_occupancy`
WHERE advertise_number = '$advertise_number';";
$result_min = mysql_query($query_min) or die(mysql_error());
while ($line_min = mysql_fetch_array($result_min))
{
$min_surface = min($line_min);
return $min_surface;
}
}
?>
Heb dit getest:
WHERE advertise_number = '$advertise_number'
AND rm_1_life_surface_in_m != 0
AND rm_2_life_surface_in_m != 0
AND rm_3_life_surface_in_m != 0
AND rm_4_life_surface_in_m != 0;";
Krijg alleen de 0 terug.
HAVING MIN(...) > 0