SQL: Sorting and Limiting results

wxdqz

New Member
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
 
Back
Top