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? Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/84042-shift-entries-in-db/#findComment-427771 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.