Ask the ID of the PHP database table How to make it appear in the page from 1 increment ordinal

Ask the ID of the PHP database table How to make it appear in the page from 1 increment ordinal
Auto-increment of ID settings in database tables but sometimes the ID is not consistent when inserting data fails or when data is deleted
I would like to output a page with each data 1 2 3 4 5 6 ..... Show in this order

I tried this one. Single-page display very simple problem is that my data is paged by the Limit statement page
To the second page from 1 2 3 4 5 .... The sequence number begins to show the

That's not a simple question.

------Solution--------------------
You're not going to change the ID in the table, but show sequential numbers when they're displayed.
Is that the only way?
Ordinal Initial value = (page number-1) * Number of rows per page +1
------Solution--------------------
The first page is 1-10 that second page is 11-20 that is the initial value (2-1) *10 and then the loop output data, the sequence number is also incremented by 1 on the line.
------Solution--------------------
Take a look at the example of the pagination class and you'll see how many pages you get total divided by the number of pages per page, looping through the pages.

