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, > >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 unless you do use an ORDER BY clause. sql, query --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
