I'm afraid there is no articles on this matter. You are facing a database
design matter.
Auto-increment primary keys must haven't any meaning other than just be the
primary key and relate one table to another, if you had a function to
"update" the auto-increment field to eliminate the holes that
Is there any way to add/delete from a MySQL database using PHP3/4 without
leaving blank records?
e.g. if record number 3 is deleted and there are 5 records in the database,
and you have auto-increment as true,
if you add a record it will go in as 6.
Either the database should be compacted so