in mysql the autoincrement field will not go back to fill gaps... and this is for a good reason ...
suppose you had an entry (bogus1) in your guest book with entry number 23 and you deleted it... now a new entry comes and it is given the entry number 23 ... well this ambigus : did u delete the original one or modified it ? also people pointing to that particular entry in their sites will be confused by the change... where as in the real life we usuallay offer a "record does not exist" type of message ... got it ?! --- Thomas Seifert <[EMAIL PROTECTED]> wrote: > Hi, > > you give less information. > How do you compute the entry number and how do you > save the entries and so on. > Normally you will have to live with the gaps but > sure, you can touch every entry > and change its number ;-). > > > Thomas > > On Sun, 1 Dec 2002 10:33:45 -0000 > [EMAIL PROTECTED] (Vicky) wrote: > > > Hiya ^_^ > > > > I have a guestbook I coded myself using PHP. In > the corner it keeps record > > of the entry number, but when I delete and entry > the entries posted after it > > don't go back to catch up. So the entry numbers > skip from 22 to 24, for > > example. > > > > Is there anyway to stop this happening, so if i > delete an entry the next one > > will follow on instead of being the number it > would have been if i hadn't > > deleted the entry? > > > > Thanks ^_^ > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > ===== +------------------------------------------+ |Wana Know what ISLAM is all about ? | +------------------------------------------+ visit : http://www.sultan.org/#int __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php