Re: [PHP-DB] Authomatic Sorting From: Dobromir Velev (diadomraz <email protected>)
Date: 07/05/01

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 <wilmar.perez <email protected>>
To: PHP List <php-db <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: php-db-unsubscribe <email protected>
>For additional commands, e-mail: php-db-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>