Hur löser man detta? Subselect, Join?
Kod: Markera allt
$resultat = mysql_query("SELECT
MIN(temperatur) AS Lowest,
MAX(temperatur) AS Highest,
AVG(temperatur) AS Average
FROM
temperatur
WHERE
var = 'Ute' AND DATE(datum) = DATE(NOW())");
while ($row = mysql_fetch_array($resultat)) {
echo "".$row['Lowest']." °C";
echo ";".$row['Highest']." °C";
echo "".round($row['Average'],2)." °C";
}