Weird ORDER BY problem with PHP an MS ACCESS
| From: | Constantin Wolber | Date: | Thu, 23 Mar 2006 15:33:12 +0000 |
| Subject: | Weird ORDER BY problem with PHP an MS ACCESS | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41596@lists.php.net to get a copy of this message | ||
Hi,
I searched quite a while for a solution but I just don't find one.
I use:
- MS ACCESS as the database (I know there are better solutions but I have to use MS ACCESS 2002)
- PHP Version 5.0.5
- Windows 2000
- Apache/2.0.54
I've got the following query:
SELECT table1.col1,
table1.col2,
table2.col1,
table3.col1,
table3.col2
FROM (table1
LEFT OUTER JOIN table2
ON table1.fkcol=table2.idcol)
LEFT OUTER JOIN table3
ON table1.fkcol2=table3.idcol
ORDER BY table2.col1,table1.col2
This Query works fine. The php page lists the results corresponding to the ORDER Statement.
Now the user can limit the result with a parameter so the SQL statemant looks like:
SELECT table1.col1,
table1.col2,
table2.col1,
table3.col1,
table3.col2
FROM (table1
LEFT OUTER JOIN table2
ON table1.fkcol=table2.idcol)
LEFT OUTER JOIN table3
ON table1.fkcol2=table3.idcol
WHERE table2.idcol=id
ORDER BY table2.col1,table1.col2
The result isn't sorted anymore, I just don't know why this can happen.
I tried the exact same query in an ODBC program and in MS ACCESS. Both times the result is sorted the correct way. Only in PHP the result isn't sorted in anyway.
Has anybody an idea what might be the problem?
Greets
Constantin