At 08:47 25/02/2006, you wrote:
Date: Sat, 25 Feb 2006 08:07:36 +0900
Message-ID: <[EMAIL PROTECTED]>
From: <[EMAIL PROTECTED]>
Subject: FW: [PHP-DB] Query select value on MAX Date
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
GROUP BY Category
Cheers - Neil
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php