Hello Marcjon,

Sunday, May 9, 2004, 12:13:05 AM, you wrote:

ML> ----- Original message -----
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

Sorry...wrong topic. I will try to not use * and i will let you know
if this solves the problem. Thanks.

Best regards,

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to