php - Get date and time of max value -

i have weather-reading database store data consumption webpage shows max , min pressure.

the problem show time , date in these values recorded.

code use read max pressure:

$max_out_pressure = mysql_query("select max(out_pressure) out_pressure $table"); $max_out_pressure = mysql_result($max_out_pressure,0,"out_pressure"); $max_out_pressure = substr($max_out_pressure, 0, 6); echo "$max_out_pressure"; echo "mbar"; 

i have columns id, datetime, pressure, temperature table named readings

webpage: http://temperatur.co.nf/readings.php

never made database or webpage before, i`m struggling this.

this maximum pressure , date recorded.

$sql = "select out_pressure, datetime         $table         order out_pressure desc         limit 1"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); $max_out_pressure = $row['out_pressure']; $max_date = $row['datetime'];