Sort search results

[TheBOSMAN]

Hi all, I have a page that is pulling my product from a sql db based on selections made by the user, they select gender first then style and this then shows all product matching. What I know need to do is give the functionality to sort by either colour, or price?

Any help with how this done would be gratefully received.

Cheers

Karl.

[Creativ_Technologies]

At the end of your SELECT statement just use ORDER BY yourVariable.