--- Gordon Stewart <[EMAIL PROTECTED]> wrote: > I want my auto-increment field to be 'tidy' > > IE - When records/lines are added / deleted - The unique reference > number just increases & increases..... - & when records are deleted - > Its got gaps.... - Im future-proofing my script now - instead of > making changes later...
If you want a value to be displayed don't use it as a primary key. The whole point of a primary key is to create a stable value which can be used for relationships between tables. If you change the primary key, you break these relationships with other tables. > > From your latest example, it seems that you are trying to renumber the > value in a field. As you have discovered, dropping and readding the column > won't do this. Nothing in your queries has actually placed a value in that > column. > < > > (ive posted 2-3 messages about this - Not sure what youve seen... > Heres the latest :- One of the things that makes answering your various questions difficult is that you post a question to the group and then find the answer yourself before the member of this group has a chance to compose their reply. There's often a delay between the time when a message is posted and when it is forwarded to the group. I saw your "fix" for using INT instead of INT(5) when my page reloaded after I composed the reply you have seen. Don't get me wrong, most of us are more than happy to help with those thorny problems. However, I certainly appreciate it when the person asking the question shows that they have made some effort to use the excellent resources such as php.net. It's a big site to be sure and finding information often relies on asking just the right question. However, the fact that you are finding answers minutes after posting a question suggests that something is out of sequence here. When I see a poster answering their own questions minutes later, it makes me wonder if I should wait in replying rather than do so at my first availability. Good luck. James _____ James D. Keeline http://www.Keeline.com http://www.Keeline.com/articles http://Stratemeyer.org http://www.Keeline.com/TSCollection http://www.ITeachPHP.com -- Free Computer Classes: Linux, PHP, etc. Spring Semester Begins Jan 31 -- New Classes Start Every Few Weeks. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
