Re[2]: [PHP-DB] another strange MYSQL problem

Hello Marcjon, Sunday, May 9, 2004, 12:13:05 AM, you wrote: ML> ----- Original message ----- ML> From: mariuspa@softhome.net ML> To: "php-db@lists.php.net" <php-db@lists.php.net> ML> Date: Sat, 8 May 2004 23:23:05 +0300 ML> Subject: [PHP-DB] another strange MYSQL problem ML> Hello, ML> First, I use this, and all is ok: ML> SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC. ML> Then, I use this: ML> SELECT * FROM modele WHERE marca='Cagiva' ORDER BY tip ASC ML> and the records are not ordered ascending by the field tip. In the ML> first case, the records were ordered. Anyone knows what is wrong? ML> Thank you! ML> Best regards, ML> Marius Panaitescu ML> -- ML> PHP Database Mailing List (http://www.php.net/) ML> To unsubscribe, visit: http://www.php.net/unsub.php ML> Well, this might not answer your question (or it might) but you should ML> not use * in your queries. Specify each column you want to retrieve. This ML> also might fix you problem, but I'm not sure. ML> -- ML> Marcjon I didn't use * to retrieve fields. I used it the first time, but no results again. When i retrieved just the field i needed, it worked, but if i try to retrieve 'id' field, the query returns no results. Best regards, Marius