ID--how to keep them in order

From: Date: Tue, 20 Dec 2005 06:12:43 +0000
Subject: ID--how to keep them in order
Groups: php.general 
Request: Send a blank email to php-general+get-227700@lists.php.net to get a copy of this message
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

« previous php.general (#227700) next »