I answered to the wrong topic for you too. They aren't sorted, at least they aren't sorted after the field 'tip' Best regards, Marius RZ> Run those queries again and send in the result set. Maybe they're being sorted RZ> but it looks off, also what is the data type for you 'tip' column. Post your db RZ> schema if possible. R>> RZ> Quoting Marcjon Louwersheimer <marcjon@xxxxxxxxxxx>: >> >> >> >> ----- Original message ----- >> From: mariuspa@xxxxxxxxxxxx >> To: "php-db@xxxxxxxxxxxxx" <php-db@xxxxxxxxxxxxx> >> Date: Sat, 8 May 2004 23:23:05 +0300 >> Subject: another strange MYSQL problem >> >> 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 >> >> Well, this might not answer your question (or it might) but you should >> not use * in your queries. Specify each column you want to retrieve. This >> also might fix you problem, but I'm not sure. >> -- >> Marcjon >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> RZ> ------------------------------------------------- -- Best regards, mariuspa mailto:mariuspa@xxxxxxxxxxxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
