I have a MySQL database table I want to retrieve data from.
The format is
[ Date ] [ Value ]
I want to retrieve 4 things from the table:
1. The latest date (call it $latest_date)
2. The value associated with the latest date (call it $latest_value)
3. The highest value in the column Value (call it $max_value)
4. The lowest value in the column Value (call it $min_value)
How do I write in my PHP script a MySQL query to retrieve those 4 things?