Re: [PHP-DB] Query select value on MAX Date

[Neil Smith [MVP, Digital media]]

At 08:47 25/02/2006, you wrote:
MIME-Version: 1.0
Content-Type: multipart/alternative;
        boundary="----_=_NextPart_001_01C63997.1A6B1B7D"
Date: Sat, 25 Feb 2006 08:07:36 +0900
Message-ID: <[EMAIL PROTECTED]>
From: <[EMAIL PROTECTED]>
To: <'php-db@lists.php.net'>
Subject: FW: [PHP-DB] Query select value on MAX Date
Dear All,

 Sorry, I wrote the wrong result.

You've posted 3x with different results so it's too confusing to work 
out what you *want* to get.

However I woudl write that query like so :

SELECT MAX(Date) as NewestDate, Value
FROM table
GROUP BY Category
HAVING Date=NewestDate

HTH
Cheers - Neil

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php