NEWS - reversing article order

Im trying to get my NEWS module to appear so first news items uploaded always stay on top, then last at the bottom. 

Currently, its set the other way round (latest news on top)

Ive tried changing the News Item ID in phpmyadmin but that doesnt seem to effect it.

Anyone know how to do this?

got it. 

Have to adjust the 'WHEN' field in phpmyadmin instead of item ID

Thanks me :-)

Very odd...

When I changed the database the articles switched but have now gone back to the way they were before!!!

Anyone got any ideas on reversing order of NEWS items?

Hello daihlo,

Without having been able to test it thouroughly, I would recommend applying a change to the file BxDolTextDb.php, where in line 63:

(case 'archive') change the $sOrderClause value from

"`te`.`when` DESC" to

 "`te`.`when` ASC"

That should work for what you ask if I understood correctly.

Regards,

kazatzo