In message <[EMAIL PROTECTED]>, Gordon Stewart <[EMAIL PROTECTED]> writes >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...
No you are not, you are trying to buck the system! Leave the gaps, for heavens sake. If you ever need to use this number as a key - lets say that you are adding a list of states, and later you want to add cities - then all the cities will have to have their states renumbered every time you change something. > >its not used (much) now - Except by me - So it doesnt matter (much) if >i screw things up... - But If I screw things up later - when its >heavily used - Thats not good.. Then keep the 'gaps' > >- Is the above script unsafe ?? No, but silly - I would fire you <G> -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com 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/
