[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
Re: [PHP-DB] another strange MYSQL problem
- 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
Re: [PHP-DB] another strange MYSQL problem
Run those queries again and send in the result set. Maybe they're being sorted but it looks off, also what is the data type for you 'tip' column. Post your db schema if possible. R 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 - -- 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
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
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
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: [PHP-DB] another strange MYSQL problem
[EMAIL PROTECTED] wrote: 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! The first query works perfectly. The second returns no results. The data type for 'tip' is text. Then you have no rows where marca is equal to 'Cagiva'... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php