Re: another strange MYSQL problem
| From: | John W. Holmes | Date: | Sun, 09 May 2004 00:37:24 +0000 |
| Subject: | Re: another strange MYSQL problem | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34323@lists.php.net to get a copy of this message | ||
mariuspa@softhome.net 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