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
