At 19:55 +0100 2/13/03, Viktor Vasiliou wrote:
Hi Stefan,
Thanks for your reply!
The table has just been created, and has therefore no deleted
entries. ID 1-1000 was created by myself, ID 1002 was created when a
new user registered at the website. ID 1001, 1003, 1004, etc is
sorted correctly.
There is three tables in the database which all get a new row when a
user signup. First, an entry is created in "tblmembers" (using
auto_increment). After that, an entry is created in two other tables
(using mysql_insert_id to set the right ID in the primary key
columns).
Any idea?
The information you provide here doesn't really address Stefan's suggestion
at all. Are you retrieving the values using a SELECT statement that
include an ORDER BY ID clause? If not, add one and see if that solves
the problem. If you are, then is your AUTO_INCREMENT column an integer
column (not a CHAR or VARCHAR or something other than integer)? If it
is an integer column, then let's see the structure of your table.
Regards,
Viktor Vasiliou
----- Original Message -----
From: Stefan Hinz
To: Viktor Vasiliou
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 12, 2003 3:34 PM
Subject: Re: Strange sorting in table
Viktor,
I have a couple of tables in a MySQL database. In one of the tables,
PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and
ID 22. Any idea why?
Have a look at the table structure. You will find 'ID' is an
AUTO_INCREMENT column. When entries are deleted, they leave "gaps".
These gaps are filled with records newly entered. So what you see is
the physical order. If you want another sort order, you could issue
"... ORDER BY ID".
Details: http://www.mysql.com/doc/en/CREATE_TABLE.html
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
