how to sort results from DB Multi Record Loader

I have a DB multi record loader and am putting the results into a drop down box. I want to sort the contents before it is put in the drop down box. How do I do that in the DB Multi Record Loader?

Thanks in advance
Dean-O

Hi Dean-O,

You can add an ORDER BY statement in the WHERE statement box like this

`section` = 3 ORDER BY `title`

You can't just have the ORDER BY part so if you aren't using a WHERE statement add a dummy one that will always be true

1 = 1 ORDER BY `title`

Bob