mysql last posting result

wxdqz

New Member
Easiest way to show the last 5 postings from a news-database? Right now I do a query to get number of rows, then use that data in the "select * from table limit 5, $rows".

Is it possible to use "limit" with "order by", and if so, how should I put it?

(Being at work, just thought of the question, so I can test it right now myself ;)

// Thomasson
 
Back
Top