Suchy Posted January 2, 2008 Share Posted January 2, 2008 I always use auto-incremented id's in my db's. The problem with that is when I deleate an entry, a hole is formed. ex. entries # ....10 11 12 13 ....., when I delete 12, the db looks like .....10 11 13 .... Is it possible for the entries to automaticaly shift when something is deleated? ex. if I delete # 12, what was 13 becomes the new 12, what was 14 becomes 13 ... If so, how can this be done? Link to comment https://forums.phpfreaks.com/topic/84042-shift-entries-in-db/ Share on other sites More sharing options...
AndyB Posted January 2, 2008 Share Posted January 2, 2008 Don't even think of messing with auto-incremented id values or 're-arranging' data. IDs are what makes a relational database different from a pile of unrelated junk. Just use a loop counter if you really want to display an entry number to visitors. Link to comment https://forums.phpfreaks.com/topic/84042-shift-entries-in-db/#findComment-427771 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.