[darcyb]

If this has been answered already, what page in this thread?

What do I need to edit (and how) to reverse the order of journal entries so that newer ones appear on top, and older ones below?

---time passes---

Ok, found it. I had to change ASC to DESC in journal.php where it says:

$fentries = $DB_site->query("
SELECT journal_entries.entry_id, journal_entries.entrytitle,
journal_entries.entrytext, journal_entries.mood, journal_entries.allowbuddies,journal_entries.entry date,
journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image , journal_entries.entry_totalrating,
journal_entries.private, journal_entries.whocanview,
COUNT(journal_comments.comment_text) AS comments
FROM ".TABLE_PREFIX."journal_entries AS journal_entries
LEFT JOIN ".TABLE_PREFIX."journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_i d)
LEFT JOIN ".TABLE_PREFIX."journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
WHERE journal_entries.journal_id='".$j."'
AND entry_active='1'
GROUP BY journal_entries.entry_id
ORDER BY entrydate DESC
LIMIT $start,$perpage
");

Now, how do I reverse the "#1, #2...#n" post URL counter so that it goes from highest to lowest from top to bottom. It's stil going #1 through #n top to bottom which looks/means funny.