ID--how to keep them in order

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux