content block order

Worker Joined: Jun 09, 2007 Posts: 172

I could not find any info in my search, please move this to where it needs to go if I have posted in the wrong area.

when i setup the content block it will show what i have setup in the content area. The order in the content is different in the block.
Is there a way to fix the order to show the way i need in the block?

example:
in the content folder
story 1
story 2
story 3
story 4

in the content block
story 1
story 2
story 4
story 3

trying to get them to be the same.

thanks for any input

registered · Posted: Fri Nov 28, 2008 7:52 am

You could try adding an "ORDER BY date" into the SQL of the block. Not sure if that is the order that you desire, but it seems like it. So, this line in block-Content.php here:

$sql = 'SELECT pid, title FROM '.$prefix.'_pages WHERE active=\'1\'';

Might look like this:

$sql = 'SELECT pid, title FROM '.$prefix.'_pages WHERE active=\'1\' ORDER BY date';

If you want it in most recent content first, it would be:

$sql = 'SELECT pid, title FROM '.$prefix.'_pages WHERE active=\'1\' ORDER BY date DESC';

Posted: Fri Nov 28, 2008 1:11 pm

Just to make sure I understand.....if i want to have the order show by date then in this line

Code:

$sql = 'SELECT pid, title FROM '.$prefix.'_pages WHERE active=\'1\'';

i just put 'ORDER By date'
and for most recent 'ORDER By date DESC'

I will try that and see what it will do

to expand on this, is there a way to set it up to change the order the same way you can change the order of blocks?

thanks for the help

edit:
when i do order by most recent, the block will show them in reverse....if i do it by date then they show correctly.

Posted: Sun Nov 30, 2008 8:56 am

gator81 wrote:

to expand on this, is there a way to set it up to change the order the same way you can change the order of blocks?

No, not without re-coding the script.

Posted: Sun Nov 30, 2008 4:13 pm

ok, thanks for the help