You are here: ID--how to keep them in order « PHP « IT news, forums, messages
ID--how to keep them in order

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация