for beginners; PHP SQL finds fields with the most recent same content with ID subtraction output difference

For beginners, PHP SQL finds fields with the most recent same content with ID subtraction output difference
The PHP MySQL database finds fields of the most recent same content, subtracting the output difference with their ID, for example: Type field (id-1, field Content 5), (Id-8, field content 9), and output 9-5 difference. Novice in detail. Thank you thank you PHP SQL MySQL

Share to:

------Solution--------------------
Don't know what you mean, suggest to post
Create Table ....;
insert into Table ...; Statement

And the expected results, and simply describe the algorithm logic.
------Solution--------------------
Read the data into an array, how to calculate it.
------Solution--------------------
At least you need to know how your data is organized.

