ORDER BY problem with iODBC and MS SQL-Server
| From: | Joachim Schade | Date: | Tue, 21 Aug 2001 13:57:14 +0000 |
| Subject: | ORDER BY problem with iODBC and MS SQL-Server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11602@lists.php.net to get a copy of this message | ||
Hi,
I use PHP 4.0.6 with iODBC and Apache 1.3.20 on a Linux System to connect a
MS SQL-Server Database on a Windows NT 4 System.
For example, the query "SELECT * FROM test" works successfully. But when I
try to add a ORDER BY clause in this statement like "SELECT * FROM test
ORDER BY name" the result ist always only 1 row although there are more rows
in the table.
As the ORDER BY problem when I add a DISTINCT in the statement it dosn't
works too.
Who can help me?
Thanks Joachim