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

2004-05-08 Thread mariuspa
I answered to the wrong topic for you too. They aren't sorted, at
least they aren't sorted after the field 'tip'

Best regards,
Marius

RZ> Run those queries again and send in the result set. Maybe they're being sorted
RZ> but it looks off, also what is the data type for you 'tip' column. Post your db
RZ> schema if possible.


R>>

RZ> Quoting Marcjon Louwersheimer <[EMAIL PROTECTED]>:

>> 
>> 
>> 
>> - Original message -
>> From: [EMAIL PROTECTED]
>> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>> Date: Sat, 8 May 2004 23:23:05 +0300
>> Subject: [PHP-DB] 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
>> 




RZ> -



-- 
Best regards,
 mariuspamailto:[EMAIL PROTECTED]

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



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

2004-05-08 Thread mariuspa
Hello Marcjon,

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




ML> - Original message -
ML> From: [EMAIL PROTECTED]
ML> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
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,
Marius

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



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

2004-05-08 Thread mariuspa
Hello Marcjon,

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




ML> - Original message -
ML> From: [EMAIL PROTECTED]
ML> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
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

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



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

2004-05-08 Thread mariuspa
The first query works perfectly. The second returns no results. The
data type for 'tip' is text.

Regards,
Marius

RZ> Run those queries again and send in the result set. Maybe they're being sorted
RZ> but it looks off, also what is the data type for you 'tip' column. Post your db
RZ> schema if possible.


R>>

RZ> Quoting Marcjon Louwersheimer <[EMAIL PROTECTED]>:

>> 
>> 
>> 
>> - Original message -
>> From: [EMAIL PROTECTED]
>> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>> Date: Sat, 8 May 2004 23:23:05 +0300
>> Subject: [PHP-DB] 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
>> 




RZ> -




-- 
Best regards,
 mariuspamailto:[EMAIL PROTECTED]

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