After repeated regions are added, you can add them in ascending order, without paging. on my webpage, add & nbsp; repeated Regions & nbsp; 50 messages are displayed & nbsp; in ascending order & nbsp; pagination is not allowed. The old information at the bottom of the page is at the top of the page. However, when more than 50 pieces of information are added, 1-50 pieces of information are displayed on the page. I don't want to display any old information when I add a new message. Thank you for adding duplicate regions, ascending order, and no paging
I want to teach you how to add repeated areas on my webpage. 50 pieces of information cannot be displayed in ascending order. The old information at the bottom of the page is at the top of the page. However, when more than 50 pieces of information are added, 1-50 pieces of information are displayed on the page. I don't want to display any old information when I add a new message. Thank you.
Paging
Share:
------ Solution --------------------
If it is read from the database, desc it first and then limit it to get the first 50.
Select * from table desc order by id limit 0, 49
If you want to sort in ascending order, select * from (select * from table order by id desc limit) order by id asc