[eluser]austintbiggs[/eluser]
After checking some DB values I've found that once a user is deleted that their ID is not reused. In fact there are gaps in between ID numbers once new accounts are created, I'm aiming to fix this "bug" in my own system.
For example, I create 5 new accounts and their ID in the DB is set to Auto_Increment. If I delete user 3 I would like for the ID 3 to be reused upon creating a new account, but instead a gap is created. Instead of using auto_increment how would I reuse the lowest available ID?
Hopefully this post is understandable.
The resulting ID numbers after the above are: 1, 2, 4, 5, [6]
