[PHP, MySQL] Get the 5 last results from a table?

[winterpartys]

Hello,

I am coding a login system/cms type and I want to get the last 5 results of registered users...
I've seen LIMIT 5 or w.e but that doesn't make any sense.
Thanks, Alex

 

[foxx]

why wouldn't it make sense?

SELECT * FROM your_table ORDER BY your_primary_key_or_date DESC LIMIT 5

 

[winterpartys]

why wouldn't it make sense?

SELECT * FROM your_table ORDER BY your_primary_key_or_date DESC LIMIT 5

I finally got back to ya!

Thanks so much! Works 100%