Run those queries again and send in the result set. Maybe they're being sorted but it looks off, also what is the data type for you 'tip' column. Post your db schema if possible. R> 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 > ------------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
