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