Page 1 of 1

SQL Qeury in php

Posted: Mon Jul 22, 2002 11:27 am
by toppac
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

Code: Select all

order by SITE, PG, GROUPNAME, rank, SKU
It seems to order by sku before ordering by rank. Any ideas?

Posted: Mon Jul 22, 2002 5:20 pm
by qads
can you post the whole sql query line, you might have a error somewhere else, or you might have to do it differnetly....