Code: Select all
LIMIT 0,#
where # is the amount you want per page. The first part is where you want to start on the list. If you keep it at 0 then the latest will show up on top. If you make 5 then the 5th latest would be on top and the items older than that would afterward. This is most likely what no one would want but you never know. You can also look at the docs at mysql.com for more info on the LIMIT modifier.