Sections module help order reverse by date/time [Module troubleshooting]

Sections module help order reverse by date/time

2005/2/8 20:47
chipthamac
Just popping in
Posts: 28
Since: 2005/1/4 2

Is there anymore information anywhere on the sections module?
Look at this page here for an example of what I am talking about.

I want the contents that I add to list in reverse order, newest at the top. Does anyone know how I could accomplish this?

Thanks in advance.
-Chip
and yes, i have checked the FAQ and searched. thx

Re: Sections module help order reverse by date/time

2005/2/11 16:08
chipthamac
Just popping in
Posts: 28
Since: 2005/1/4 2

i looked at the index.php file under modules/sections but I can not find where to change the ASC to DESC so that it reverses higher article id's first.
Any help on this would be greatly appreciated.

Re: Sections module help order reverse by date/time

2005/2/11 16:17
Dave_L
XOOPS is my life!
Posts: 2277
Since: 2003/11/7

(not tested)

modules/sections/index.php, function listarticles:

 $result = $xoopsDB->query("SELECT artid, secid, title, content, counter FROM ".$xoopsDB->prefix("seccont")." WHERE secid=$secid [color=ff0000]ORDER BY artid DESC[/color]");

Re: Sections module help order reverse by date/time

2005/2/11 17:15
chipthamac
Just popping in
Posts: 28
Since: 2005/1/4 2

Dave,
Thanks so much for responding so quickly.
That worked EXACTLY the way I wanted it too.
Thanks again, I appreciate it.
Tested. Works.
:)

Re: Sections module help order reverse by date/time

2005/2/16 2:56
chipthamac
Just popping in
Posts: 28
Since: 2005/1/4 2

Hey Dave, one more thing, would thier be anyway for me to make a sublink in sections of the most popular links?
If you have time to answer this, if not cool, i'll just fool around with the code. :P
Thanks.

Stats
Goal:	$100.00
Due Date:	Jan 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Sections module help order reverse by date/time

Re: Sections module help order reverse by date/time

Re: Sections module help order reverse by date/time

Re: Sections module help order reverse by date/time

Re: Sections module help order reverse by date/time

Login

Search

Recent Posts

Re: AI circumvent anti spamm

Re: AI circumvent anti spamm

AI circumvent anti spamm

Re: xoops_redirect

Re: Help to import database

Re: Help to import database

Re: xoops_redirect

Re: XOOPS MyMenus 1.54.0 Beta 10

Re: xoops_redirect

Vulnerability in xmnews, xmsocial and xmarticle modules

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}