Output 10 news for the next dates (DLE)?

Question

CMS

Good afternoon, I created a site on DLE, the subject of the release date of films. You need to organize the output of the next releases, for example, a block with 10 nearest dates. Dates are taken from the date of publication, the date is set for the future. The system organizes the display of 5 latest news, but with future ...

Answer 1

In the same way as with the latest news, only you sort the date from the current one, an example in SQL

SELECT * FROM table WHERE publish_date >= CURDATE() ORDER BY publish_date ASC LIMIT 10