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@xxxxxxxxxxxx> wrote in message news:1634388177.20040508232305@xxxxxxxxxxxxxxx > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
