Ordering Display Latest news module

jakob · 27.10.2004, 13:48

Currently my "Display Latest News" module is ordered by creation date. I am trying to make it order the news by publication date.

I have been trying to modify the module file, specifically changing:

Code:

	. "\n  ORDER BY a.created DESC"

(line 339 or something like that)

to:

Code:

	. "\n  ORDER BY a.publish.up DESC"

But it didn't work. Anyone know how to do this?

vrajesh · 28.10.2004, 20:17

Hi,

Is this existing module or are you using module from Stingrey's site?

Regards,

Vrajesh

jakob · 29.10.2004, 12:42

I'm using the one from Stingrey's site.

vrajesh · 29.10.2004, 14:37

PHP Code:

  . "\n  ORDER BY a.publish.up DESC"

should be a.publish_up . see the underscore. May be a typo.

Regards,

Vrajesh

jakob · 29.10.2004, 20:59

And there is was - right in front of me

Thank you

lordprodigy · 03.04.2006, 02:14

hello, I am trying to order them by creation date but inversely. the newest one comes last, the oldest one comes first. how can I do that? thanks.