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
- Visit your group "php-list" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.