mysql - How can I "display more" in a list? -

Items sorted by date, like the next 15 values ​​in the table?

It looks like you need to see the LIMIT clause:

DESC LIMIT 0, 15; dated by order from / p>

  SELECT * FROM items  

To display the next 15 items, just replace 0 to LIMIT section 15 ... then again 30 ... again 45 ... and so on. It is said to mark the page.