[restless]

well, i figured it out myself. maybe this is already posted somewhere, but i sure can't find it.

forgive me if this is old news:

if anyone wants to have the journal entries show the latest entry first, open up journal.php and find the following code:

PHP Code:

$fentries = $DB_site->query(" 
                         SELECT journal_entries.entry_id, journal_entries.entrytitle, 
                         journal_entries.entrytext, journal_entries.mood, journal_entries.allowbuddies,journal_entries.entrydate, 
                        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_id)
                     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 ASC 


in the last line, change ASC to DESC