Hello guys, i have a php challenge here. Anyone to help me with it?

Question

Well lets say there are going to be 7 records in a mysql table.

r1, r2, r3, r4, r5, r6, r7

if r1 = to any number, r2 should not be greater than r1.
and r3 should not be greater than r2 and r4 should not be greater than r3..... and so on like that up to the last record.

But obviously, the records are not limited to seven.

How can i go about it? Code sample would be great.

Answer 1

Sort them using orderby and update in descending order