Update Row Value If Another Row is Deleted

After you delete a row, you can update the other rows where the rank is higher. You just need to know what rang was deleted. Something like this:

Code:

UPDATE SOMETABLE SET RANK = RANK + 1 WHERE RANK > ?

You can do this in your code, or with a database trigger, or if you use CI4, with a model event (before delete or after delete): https://codeigniter4.github.io/userguide...parameters

This works perfectly!, Thank you so much for the help!