Re: another strange MYSQL problem

What I suggest you do, run phpMyAdmin (Or whatever you use) and dump the table structure for your table. Also give us a few lines of typical data from your table. Your queries looks correct to me. -- -- Kim Steinhaug ---------------------------------------------------------------------- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. ---------------------------------------------------------------------- www.steinhaug.com - www.easywebshop.no - www.webkitpro.com ---------------------------------------------------------------------- <mariuspa@softhome.net> wrote in message news:1634388177.20040508232305@softhome.net... > Hello, > > First, I use this, and all is ok: > > SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC. > > Then, I use this: > > SELECT * FROM modele WHERE marca='Cagiva' ORDER BY tip ASC > > and the records are not ordered ascending by the field tip. In the > first case, the records were ordered. Anyone knows what is wrong? > Thank you! > > Best regards, > Marius Panaitescu