----- 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
