Re[2]: another strange MYSQL problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Marcjon,

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




ML> ----- Original message -----
ML> From: mariuspa@xxxxxxxxxxxx
ML> To: "php-db@xxxxxxxxxxxxx" <php-db@xxxxxxxxxxxxx>
ML> Date: Sat, 8 May 2004 23:23:05 +0300
ML> Subject:  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,
Marius

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux