Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

[PHP-DB] Authomatic Sorting From: Wilmar Pérez (wilmar.perez <email protected>)
Date: 07/04/01

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>