I have an ordered array of IDs gathered from complex SELECT query.
Now I need to get entities with IDs from my array but in the order they are listed in IDs array!
It can be done with this query:
SELECT * FROM table WHERE id IN (5,4,3,1,6) ORDER BY FIELD(id, 5,4,3,1,6);
But the porblem...
I have followed this tutorial and it's working fine but I don't know how to add more fields to that option dynamically, here's my template:
<xen:foreach loop="$preparedOption.option_value" key="$choice"...