<div>
Here's the SQL: 
 
1 and 2: 
&nbsp; SELECT `Value`, `Date` 
&nbsp; FROM table 
&nbsp; HAVING `Date` = MAX(`Date`) 
 
3: 
&nbsp; SELECT MAX(`Value`) FROM table 
 
4: 
&nbsp; SELECT MIN(`Value`) FROM table 

</div>

Here's the SQL:

1 and 2:
  SELECT `Value`, `Date`
  FROM table
  HAVING `Date` = MAX(`Date`)

3:
  SELECT MAX(`Value`) FROM table

4:
  SELECT MIN(`Value`) FROM table


<div>
<div class="content wysiwyg-content">
PHP MYSQL 
 
Hello, 
 
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? 
 
 
Thanks.
</div>
</div>

PHP MYSQL

Hello,

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?


Thanks.

PHP MYSQL: How to retreive (1) latest date, (2) value associated with latest date, (3) largest value (4) lowest value?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.