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
HI,
Look into Optimizing the Table..
it seems to clean up the holes.
Ken
- Original Message -
From: Wilmar Pérez [EMAIL PROTECTED]
To: PHP List [EMAIL PROTECTED]
Sent: Wednesday, July 04, 2001 1:50 PM
Subject: [PHP-DB] Authomatic Sorting
Hello guys
I have the following two problems
after deleting a row:
UPDATE table SET id_field=id_field-1 where id_fielddeleted_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
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,
on 7/4/01 1:50 PM, Wilmar Pérez at [EMAIL PROTECTED] wrote:
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:
snip
Just add an ORDER BY clause to
D you ever create an index on the primary key to speed things up??
ken
- Original Message -
From: Paul Burney [EMAIL PROTECTED]
To: Wilmar Pérez [EMAIL PROTECTED]; PHP List
[EMAIL PROTECTED]
Sent: Wednesday, July 04, 2001 3:18 PM
Subject: Re: [PHP-DB] Authomatic Sorting
on 7/4/01 1:50
To: PHP List
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