Just working with a database and some tests were done recently which checked the integrity of the setup.
As a result, a lot of test entries were added which were then deleted. However, when new entries are added, the ID number value continues from after the entries added.
What I want: ID increases by one from where it left off before the additional rows were added: 4203, 4204, 4205, 4206 etc.
What is happening: ID increases by one from after the additional rows ID: 4203, 4204, 6207, 6208 6209 etc.
Not sure where to fix this...whether in phpmyadmin or in the PHP code. Any help would be appreciated. Thanks!