SQL Qeury in php
Posted: Mon Jul 22, 2002 11:27 am
I am using the OCI functions to run a rather large query. I want to sort the results by 4 different criteria. When I run this query just against the database it comes back fine. But when I run it using php and OCI, it seems to ignore my ORDER BY command. Is there a limit to the number of ORDER BY elements you can have? My ORDER BY looks like this
It seems to order by sku before ordering by rank. Any ideas?
Code: Select all
order by SITE, PG, GROUPNAME, rank, SKU