Re: Re: Strange sorting in table

Paul, Thanks for the explanation! Best Regards, Viktor Vasiliou - Original Message - From: Paul DuBois To: Viktor Vasiliou ; [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:05 AM Subject: Re: Re: Strange sorting in table At 0:01 +0100 2/14/03, Viktor Vasiliou wrote: Ok, I

Re: Strange sorting in table

- 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

Re: Strange sorting in table

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

Re: Strange sorting in table

, 2003 10:23 PM Subject: Re: Strange sorting in table 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

Re: Re: Strange sorting in table

Stefan and Paul, When adding ORDER BY counterid, all rows are sorted correctly, but it should not be needed. All the other tables are sorted correctly at the start, and has always been. I'm not sure where you got that idea. There is NO guarantee about the order in which rows are returned

Re: Re: Strange sorting in table

Ok, I guess you're right. It's just that it has never happend to me before. Thanks for your help. Regards, Viktor - Original Message - From: Paul DuBois To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 11:48 PM Subject: Re: Re: Strange sorting in table Stefan and Paul

Re: Re: Strange sorting in table

At 0:01 +0100 2/14/03, Viktor Vasiliou wrote: Ok, I guess you're right. It's just that it has never happend to me before. Thanks for your help. In general, when you simply insert rows into a table, that's the order in which they're returned. That's just happy coincidence, and not to be relied

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.