SQL: Sorting and Limiting results

[Anon]

Hi,

I have a php page that gets a list of posted details from a table, but I only want the last 12 records (most recent).

I've tried:

SELECT * FROM misc4 ORDER BY date LIMIT 12

But that just gives me the first 12.

What's going wrong?

Thanks,
Manteau

[Anon]

ORDER BY date DESC