I'm not sure why this would cause any problems for you. When you query the database, the missing record with ID 4 shouldn't be an issue. What in particular are you experiencing?


  --- Debbie Woods <[EMAIL PROTECTED]> wrote:

  > What database are you using?

  Sorry I should have mentioned this.
  I use mysql 4 and php 5.

  Thanks!

  Anna Vester

  > 
  >   Hello group,
  >
  >   I have another question about record deletion from
  >   database.
  >
  >   For example, my database has 10 records with ids 1
  >   through 10. If I delete id #10 then everything is
  > good
  >   and all the records are still 1 through 9.
  > However, if
  >   I delete record id #4, then in my db I would have
  >   records 1 through 10 with id #4 missing.
  >
  >   Is there a command that syncs the database? How do
  > I
  >   go about this to keep all the ids in the right
  > order
  >   after the deletion? or What do I need to do to
  > prevent
  >   that from happenning?
  >
  >   All the help is appreciated.
  >
  >   Anna Vester
  >   http://www.veanndesign.com
  >   http://reviews.veanndesign.com


[Non-text portions of this message have been removed]



Community email addresses:
  Post message: php-list@yahoogroups.com
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list




SPONSORED LINKS
Php mysql Job postings


YAHOO! GROUPS LINKS




Reply via email to