How to scroll through all the news in Opencart?

Question

SQL

Can anyone tell me how to write a script in Opencart that will open the page of the next product in turn every time it is opened?
That is, it is necessary to store the last visited ID in a local file.
We pull it out, select the next product ID in the database and form a link to it.
How to generate a link? :(

Answer 1

Выбрать Максимум(дата) из Таблицы с группировкой по Имя

If you need a record ID, make a subquery of this query and associate it with the main table by name and date.

Answer 2

$this->url->link('product/product', 'product_id=' . $product_id)