Getting values where one equals max value

[AndyTussel]

I have a table that stores temperature and humidity data along with a date and an ID. The column names are:

id, temperature, humidity, created_date

How can I display the id, temperature, and created_date for the record with the highest temperature?

I'm considering something like:

sql
Copy code
$sql = "SELECT id, temperature, humidity, created_date FROM tbl_temperature WHERE temperature = ****";
What should echat koows I use in place of the ****?

Thank you!