PDA

View Full Version : Select record with most recent date...

Dodger
10-17-2002, 09:06 PM
I should know this...but don't...

Please help.

TIA.
Spookster
10-17-2002, 10:01 PM
You could

SELECT * FROM tablename ORDER BY datefield DESC LIMIT 1
Dodger
10-18-2002, 07:35 AM
duh! that's so easy...

Thanks! ;)