Re: Authomatic Sorting

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@caribe.udea.edu.co> To: PHP List <php-db@lists.php.net> 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@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >