Forum sorting.

LOL You serious?

Yes, I'm serious. It's more interesting seeing the last activity in the thread instead of seeing the start every time you open it. Just think of the way one reads a journal. One reads the latest activity first. Most email system do as well. When you click reply you start to write on top with the history further down.

If you look in viewforums.php and viewthread you should find code similar to:
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]if ($rows) {
$result = dbquery(
"SELECT t.*, tu1.user_name AS user_author, tu1.user_status AS status_author,
tu2.user_name AS user_lastuser, tu2.user_status AS status_lastuser
FROM ".DB_THREADS." t
LEFT JOIN ".DB_USERS." tu1 ON t.thread_author = tu1.user_id
LEFT JOIN ".DB_USERS." tu2 ON t.thread_lastuser = tu2.user_id
WHERE t.forum_id='".$_GET['forum_id']."' AND thread_hidden='0'
ORDER BY thread_sticky DESC, thread_lastpost DESC LIMIT ".$_GET['rowstart'].",$threads_per_page"
);[/syntaxhighlighter]

Check out the last line. "ORDER" by "DESC". Try and change that to "ASC"

Se also http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html among others places. There may by other implications to this, but just post your troubles and we will try to help.

Help. Right Craig?