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? 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
