MySQL - Aus Spalte 3, maximaler Wert ermitteln, gesamte zeile in arry ausgeben

-- MAX
select
    t0.dateid AS max_dateid,
    t_max.max_temp
from
    myTable AS t0,
    inner join(
        select t1.date, max(t1.temp) as max_temp
        from myTable AS t1
        group by t1.date
    ) AS t_max
    on t0.date = t_max.date
;

-- MIN
select
    t0.dateid AS min_dateid,
    t_min.min_temp
from
    myTable AS t0,
    inner join(
        select t2.date, min(t2.temp) as min_temp
        from myTable AS t2
        group by t2.date
    ) AS t_min
    on t0.date = t_min.date
;

<?php
mysql_connect('localhost', 'user', 'paswort') or die  ("Keine Verbindung möglich: ".mysql_error());
mysql_select_db('dbname') or die  ("Keine Verbindung möglich: ".mysql_error());

$sql  = "SELECT
    t0.dateid AS max_dateid,
    t_max.max_temp
FROM
    tabellename AS t0,
    INNER JOIN(
        SELECT t1.DATE, MAX(t1.temp) AS max_temp
        FROM tabellenname AS t1
        GROUP BY t1.DATE
    ) AS t_max
    ON t0.DATE = t_max.DATE WHERE date = '2016-04-15'"
;
mysql_query($sql);
echo mysql_affected_rows();
?>

echo mysql_affected_rows();

echo mysql_affected_rows();

mysql_connect('localhost', 'XXXXXXX', 'XXXXXXXXXXXX') or die  ("Keine Verbindung möglich: ".mysql_error());
mysql_select_db('XXXXXXXXXX') or die  ("Keine Verbindung möglich: ".mysql_error());


$sql  = "SELECT
    t0.dateid AS max_dateid,
    t_max.max_temp
FROM
    wswinbasisdatena AS t0,
    INNER JOIN(
        SELECT t1.DATE, MAX(t1.temp) AS max_temp
        FROM wswinbasisdatena AS t1
        GROUP BY t1.DATE
    ) AS t_max
    ON t0.DATE = t_max.DATE WHERE date = '2016-04-12'"
;
mysql_query($sql);
echo mysql_affected_rows();

echo $sql;

echo $row['t_max.max_temp'];

<?php
//mit deiner datenbank verbindung ersetzen
include("db.php");

//dein wettertabellen Name
$tableName = "wswinbasisdatena";


//die html parameter in variablen speichern
$param_datum = $_GET["pickeddate"];

//hier die neue sql ?pickeddate=2013-01-09
$query = "SELECT dateid, date, min(temp) as minimum  FROM $tableName WHERE date = '$param_datum' GROUP BY dateid ORDER BY dateid ";
$result = mysql_query($query);

$linecounter = 0; //counter initialisieren


// ab hier wird jeder datensatz einzeln abgearbeitet
while($row = mysql_fetch_array($result))
{


$tempmin = ".$minimum.";

// und jetzt die amcharts datensatzzeile zusammenbauen und ausgeben, der erste datensatz wird ohne komma ausgegeben
    if ($linecounter == 0){
    echo  ".$tempmin.";}
    else{
    echo ".$tempmin.";
    }


$linecounter++; //counter raufzählen
//ende
}


?>

<?php

//Datenbank Verbindung
$link = mysqli_connect("hostname", "xxxxxx", "xxxxxx", "xxxxxxx");

//die html parameter in variablen speichern
$param_datum = $_GET["pickeddate"];


//Query 1: Datenbank Abfrage zum Werte Berechnen (max/min/avg/sum etc.)
$query1 = "
SELECT
    DATE(date) AS d,
    MAX(temp) AS tMax
 
FROM wswinbasisdatena
WHERE date = '$param_datum'
ORDER BY d  DESC
LIMIT 1
";

//Query ausführen
$result = mysqli_query($link,$query1);

//Zeilen Ausgeben
while($row = mysqli_fetch_array($result))
{
    echo "Datum: ".$row[d]." Max. Temp: ".$row[tMax]."<br>";
}

//php end
?>

$row['tMax']