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

Reply via email to