Re: ID--how to keep them in order

On Tue, Dec 20, 2005 at 02:12:43PM +0800, Anasta wrote: > I have a script which outputs a movie title, rating and the ID number > (below). > The ID number is also used in the admin section as a select for update and > delete. > > The problem i have is that as i delete certain entries then the number > sequence on the display page has missing numbers--is there a way to move all > rows down to the next number in the mysql DB so the ID remains there. > The easiest way is to not display the ID in the first place i am guessing, > but it would be good to know if there is another way. > > There are 16 DVDs titles. > 2 Monster in Law PG > 3 Pulp Fiction MA This is more of a db design issue, what your are looking at is the issue with: surrogate key vs. natural key Curt. -- cat .signature: No such file or directory