Authomatic Sorting
| From: | Wilmar Pérez | Date: | Wed, 04 Jul 2001 20:50:00 +0000 |
| Subject: | Authomatic Sorting | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10059@lists.php.net to get a copy of this message | ||
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
-----------------------------------------------