Posted by Curt Zirzow on 12/20/05 09:16

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

[Back to original message]