When you delete a record it doesn't affect the other ones, so if you want to
change the other ones you have to update them too.
For this purpose I use the following SQL command after deleting a row:
UPDATE table SET id_field=id_field-1 where id_field>deleted_ID_value
I hope this will help
Dobromir Velev
-----Original Message-----
From: Wilmar Pérez <[EMAIL PROTECTED]>
To: PHP List <[EMAIL PROTECTED]>
Date: Wednesday, July 04, 2001 11:45 PM
Subject: [PHP-DB] Authomatic Sorting
>Hello guys
>
>I have the following two problems:
>
>I've got a table with an autoincrement field which is the registry's ID,
>everything goes well until I delete any registry. MySQL doesn't re-sorts
>the information. That is, I have the following:
>
>001 user1
>002 user2
>003 user3
>
>If I delete user2, I would like to have something as shown next:
>
>001 user1
>002 user3
>
>But instead I end up with the following:
>
>001 user1
>003 user3
>
>Any idea or comment?
>-----------------------------------------------
> Wilmar Pérez
> IT Manager - Central Library
> University of Antioquia
> Medellín - Colombia
> tel: ++57(4)2105145
>-----------------------------------------------
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]