Quote from: sottwell at Nov 22, 2005, 04:44 AM
As far as sorting your news display goes, the sql query is on line 125 of the snippet itself. You could easily modify that to anything you like. The createdon field is the value being used to for the ORDER BY value in the final query.
Line 125 of ’NewsLister’ snippet exactly is:
$output = '';
// initialize the blog variable
Nothing realted to SQL query, at all. Also, this snippet completely lacks any ’order’ word.
I found ’SELECT’ at lines 211 and 216, and sewed the following to their tails:
."' ORDER BY 'menuindex' DESC";
No matter how i change ASC to DESC and back, my news remain in entry order ;( (’menuindex’ is different, i did verify).
P.S. IMHO the info about content ordering pertains to content itself too, and once set in Manager should be retained across all and any front-end routines. Lack of such a behavior is definitely a design flaw - i found no field like ’sort_by’, or does it exist anyway ?