RE: Order Problem
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
> Date: Wed, 7 May 2008 19:54:39 +0200> To: neildtompkins@xxxxxxxxxxx> Subject: Re: Order Problem> From: leannonn@xxxxxxxxx> > Hi,> > You should look at the `FIND_IN_SET` function here: > http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set> > Your query could look like:> SELECT ProductID FROM Products WHERE Enabled= ' Yes' AND ProductID > IN(varProductID) ORDER BY FIND_IN_SET(ProductID, varProductID);> > Haven't tested it, though...> > > Take care,> Aleksandar
_________________________________________________________________
Discover and Win with Live Search
http://clk.atdmt.com/UKM/go/msnnkmgl0010000007ukm/direct/01/