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]

Reply via email to