Posted by "Anasta" on 12/20/05 08:12
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
4 Bambi G
5 Shrek PG
6 Madagascar G
7 Grease II PG
8 Star Wars M
9 Harry Potter-Askaban PG
10 Lilo & Stitch G
11 Garfield G
13 Saw I MA
14 Saw II MA
15 Longest Yard R
16 Robots PG
17 Bewitched PG
20 Team America PG
Navigation:
[Reply to this message]
|