Re[2]: [PHP-DB] another strange MYSQL problem
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
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
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
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