The list page in the background moves down one position in the order, and then drops one position in the order. then, the foreground changes at the same time. how can this problem be achieved?

In the back-end list page, one place is moved up in the order, and one place is dropped when the point is dropped, and the front-end changes at the same time. how can this be implemented? In the back-end list page, one place is moved up in the order, and one place is dropped when the point is dropped, and the front-end changes at the same time. how can this be implemented? For more information, thank you! ------ Solution ------------------ the database has this field or time field, and the list is displayed as the list page of the orderby field background. in the order, point up and move up one bit, point drop will drop one, and then the foreground will change at the same time. how can this be achieved?
In the back-end list page, one place is moved up in the order, and one place is dropped when the point is dropped, and the front-end changes at the same time. how can this be implemented? For more information, thank you!

------ Solution --------------------
The database has this field or time field,

The list displays the order by field

Each time you click, it is actually to update the information of a single data or modify its field value,

Then return to the list.

For example, you have a list and each field information has a cn_time (time) or cn_index (value) field. [by the way, index is a keyword in the database]


Select * from list order by cn_time


Every time you click, the resource id data is updated.

Update list set cn_time = now;



In this way, the functions you mentioned are implemented,