selecting max date and ID

[thawes]

Hey guys,
I have a table that contains a date field (0000-00-00) and then an auto-increment ID field. I want to have a select statement that will show me the most current record. So i've tried the following select statement:

select max(date) AS mydate, ID from table;

But this never works. All I want to get is the date and the ID of the most up-to-date/current record.

ANY HELP WOULD BE HUGE...thanks

[devinemke]

SELECT * FROM table ORDER BY date DESC LIMIT 1