PHP to do a ranking, according to the time ranking, the chart is in reverse chronological order, queued fields need to be ordered by time.
The correct queuing sequence and sequence number are reversed 5.4.3.2.1
Reply to discussion (solution)
I'm a master of magic!
Not order by time, okay?
If you sort by ID, you can write this
SELECT * FROM table order by id desc;
Not order by time, okay?
This method is OK, but the preceding sequence number is according to Desc, and the back line is according to ASC, so tangled yes. The boss is so picky.
Your queue column has no data.
ORDER BY Field
DESC or ASC
Ascending desc
Descending ASC
Your queue column has no data.
Well, no data, the ordinal column is $key, is in descending order. Row sequences need to be sorted in ascending order, and SQL statements can only be ordered once. So now I'm struggling. The initial intention is to add a field and then write a looping statement that writes the rank to this field. Keep looping the IDs so that each piece of data has a value for the sort field. But it doesn't loop by ID.
What is the basis of your ranking?
What is the basis of your ranking?
The ranking is based on the time ascending, and the ordinal is based on the time descending. So two conflicts.
Your serial number is generated when the PHP code is output.
So your ranking is the total number-serial number
Ordinal rank 1 2 5 1
Your serial number is generated when the PHP code is output.
So your ranking is the total number-serial number
Ordinal rank 1 2 5 1
That's right, I just want this effect. How did that come out? Just help me with that, I don't understand.
The total number of records to get the results of the query isn't that hard?
So
echo ' serial number '. $i. ' Rank '. ($count-$i);
$i + +;
No, it's okay?