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