DEDECKTS, how do I change the list of articles in order of time?

Dreamweaver's default list is arranged in reverse order of the release time. This is also the common method of many dynamic article lists, but what I need to do now is to follow the order of first come first served, not to catch up. That was to say, the first one was posted on top, and the second one was posted on the bottom. May I ask how this can be achieved?

Answer 1

If you want to arrange the articles in the database in time order, you can create a new table in the "database" tab and list the date as a time stamp in the table. You can then use an SQL statement to combine the columns of the table into a query and use the query to arrange the list of articles in temporal order.

For example, let's say we have a diary application called "Write an article" and we need to arrange all the articles in time order. We can create a new table and query by following these steps:

1 Create a new table in the "database" tab called "writing time"(note that the column name of the table should be the same as the name of the table).

2 Add a time stamp column to the "Writing time" table. The value of this column is the current date.

3. Use a combination of SQL statements to get the title and date of all the articles.

```
SELECT title DATEFROMPARTS(year(date) month(date) day(date)) AS date
From Writing
```

The query will return the title and date of all articles. The "title" column is the title of the article, and the "date" column is the date of the article.

4 Use the above query to arrange the list of articles in time order.

5. Use the END statement to insert the title and date of the article into the new table.

6 Close the table and query.

After completing these steps, we can arrange the articles in the new table in order of time.