I've created a database which reference the autoincrementing key.
On a listing page, the page pulls the fields from the database, including the auto-incrementing id field. When they click delete, it sends the ID of that entry to the delete function:
$entrydb = new TextDB;
$entrydb->open("data/circuit");
$check = $entrydb->erase($entrydb->find("cid", $id));
When going back to the list, it's gone, however, viewing any id number higher than that becomes problematic. (ie: When I delete record 20, viewing 21 shows 22's information, viewing 22 show's 23's info, etc.)
What can I do, if anything to fix this?
-Roy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've created a database which reference the autoincrementing key.
On a listing page, the page pulls the fields from the database, including the auto-incrementing id field. When they click delete, it sends the ID of that entry to the delete function:
$entrydb = new TextDB;
$entrydb->open("data/circuit");
$check = $entrydb->erase($entrydb->find("cid", $id));
When going back to the list, it's gone, however, viewing any id number higher than that becomes problematic. (ie: When I delete record 20, viewing 21 shows 22's information, viewing 22 show's 23's info, etc.)
What can I do, if anything to fix this?
-Roy