$sql = "SELECT *
                FROM $table
                WHERE timestp BETWEEN $encours AND $now 
                AND T1_PAPP = ( SELECT  MAX(T1_PAPP)  FROM $table )";

bonjour,
[php]
$sql = "SELECT *
FROM $table
WHERE timestp BETWEEN $encours AND $now
AND T1_PAPP = ( SELECT MAX(T1_PAPP) FROM $table )";
[/php]

<?php
$host="localhost";
$username="root"; 
$password=""; 
$db_name="ecodevices";
$table = "infoeco";
$con=mysql_connect("$host", "$username", "$password")or die("Connexion sql refusé"); 
mysql_select_db("$db_name")or die("Connexion sql refusé");
$now = time();
$jour = 86400;
$encours = $now-$jour;
$sql = "SELECT timestp, MAX(T1_PAPP) as pmax
		FROM $table
		WHERE timestp BETWEEN $encours AND $now";
		
		$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
extract ($row);
}
echo 'Pmax : ',(int)$pmax, ' W ', ' à ',date("H:i",$timestp),'.';
?>

Bonjour,
Je voudrais récupérer l'heure d'une valeur maximum des dernières 24h. Avec ce code j'ai l'heure du dernier enregistrement et non l'heure de la valeur max.
Voici mon code :[php]<?php
$host="localhost";
$username="root";
$password="";
$db_name="ecodevices";
$table = "infoeco";
$con=mysql_connect("$host", "$username", "$password")or die("Connexion sql refusé");
mysql_select_db("$db_name")or die("Connexion sql refusé");
$now = time();
$jour = 86400;
$encours = $now-$jour;
$sql = "SELECT timestp, MAX(T1_PAPP) as pmax
FROM $table
WHERE timestp BETWEEN $encours AND $now";

$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
extract ($row);
}
echo 'Pmax : ',(int)$pmax, ' W ', ' à ',date("H:i",$timestp),'.';
?>[/php]
Merci.