SQL Qeury in php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
toppac
Forum Commoner
Posts: 29
Joined: Fri Jun 14, 2002 10:44 am

SQL Qeury in php

Post 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?
qads
DevNet Resident
Posts: 1199
Joined: Tue Apr 23, 2002 10:02 am
Location: Brisbane

Post 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....
Post Reply