Index changes when searching / sorting

[ghost]

When sorting a table or filtering a table the indexes are recalculated. So what used to be index 64 can now be index 0 when by sorting the table this row is now the first row.

Anything we can do about this?

[ghost]

Anyone wondering. I've sort of fixed it for now by adding another value to the array called original_index and just using that further on in the code.

Did it by having PHP add it to the array before spitting it out as JSON:

        $i = 0;
        while ($row = $result->fetch_assoc()) {
            $row["original_index"] = $i++;
            $json[] = $row;
        }