'>
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
& Regards,
Anita
From: Adman, Nur anita
Sent: Saturday, February 25, 2006 6:05 AM
To: 'php-db@lists.php.net'
Subject: RE: [PHP-DB] Query select value on MAX Date
Dear All,
I have table like this :
Id | Category |
Dear All,
I have table like this :
Id | Category | Date|
Value
1 | A | 2005-02-21 |
2000
2 | A | 2004-01-21 |
3000
3 | B | 2006-01-2
