ORDER BY query....

[The_Chancer]

I am needing to specify an order for a query after specifying the "WHERE" aspect.. sort of as follows:

SELECT * FROM properties WHERE clientid='' AND 
( location='314' OR location='338' OR location='337' OR location='339' OR
 location='316' OR location='315' OR location='336' OR location='335' OR location='317' OR location='318' ) AND status!='Sold' ORDER BY location IN 
('314','338','337','339','316','315','336','335','317','318') DESC LIMIT 0,25

Yet it isn't quite giving me what I need (the order is still skewed). The order should be as the "WHERE" specifies or as the "ORDER BY" part specifies.. Can anyone point me in a better direction ??

Thanks,

[edit]
That was one long ass query... split onto more lines...[/edit]

[leatherback]

Hm

hasve you tried:

SELECT * FROM properties WHERE clientid='' AND 
( location IN ('314','338','337','339','316','315','336','335','
317','318')) AND status!='Sold' ORDER BY location DESC LIMIT 0,25

[The_Chancer]

Yup - tried it, because of the index key (on the id column) it does it by those, even if I place an index on the location column, it orders those by numerical index, which is not necessarily what is required. I need to specify the order - which could well be (1,99,2,98,3,97) etc, but this would come out of the database as 1,2,3,97,98,99 effctively screwing with the order.

I am working on a way round with setting the details in an array, then splicing out the required id's from the $info array given by the basic select command without the ORDER BY clause. Seems to be working at the moment, just needs a little refining. But I think that the order by would work so much faster, as searching a multi-dimensional array slows the page by a good couple of seconds trying to parse only a few records..... Either that or the server is knackered... LOL