----- 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
