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?
> 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. Please send the table structure of the table in question, plus the (three rows of) data, i.e. DESCRIBE tbl and SELECT ID FROM tbl 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