• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 645
  • Last Modified:

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

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.
0
gingera
Asked:
gingera
  • 2
1 Solution
 
Rob SiklosCommented:
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
0
 
Rob SiklosCommented:
so in PHP, you can do it like this:

// 1 and 2
$sql = "SELECT `Value`, `Date`
  FROM table
  HAVING `Date` = MAX(`Date`)";
 
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$latest_date = $row['Date'];
$latest_value = $row['Value'];
 
// 3 and 4
$sql = "SELECT MAX(Value) AS maxval, MIN(Value) AS minval FROM table";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$max_date = $row['maxval'];
$min_value = $row['minval'];

Open in new window

0
 
gingeraAuthor Commented:
THANKS
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now