<?
chdir("/home/ymuk/public_html/forum/");
include("global.php");

        $num_active = 7;

        $db=mysql_connect($servername,$dbusername,$dbpassword);
        mysql_select_db($dbname);

        $querylatest="SELECT * FROM thread WHERE forumid='2' ORDER BY dateline DESC LIMIT $num_active";

        $resultlatest = mysql_query($querylatest,$db);

        while ($latest_array = mysql_fetch_array($resultlatest)) {

        // split the date up a bit
        $datestr1 = substr($latest_array["dateline"],0,10);
        $datetime = substr($latest_array["dateline"],11,8);

        $querythread="SELECT * FROM post WHERE threadid='$latest_array[threadid]' ORDER BY dateline ASC LIMIT 1";

        $result_thread_text= mysql_query($querythread,$db);

        $result_thread_array = mysql_fetch_array($result_thread_text);

        $newstitle = $latest_array["title"];
        $newsposter = $latest_array["postusername"];
        $newsposterid = $result_thread_array["userid"];
        $newsdate = date("D j M Y", $latest_array["dateline"]);
        $newstext = bbcodeparse($result_thread_array["pagetext"],2,1);
        $newsthreadid = $latest_array["threadid"];
        $newscomments = $latest_array["replycount"];

        print("<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"3\"><b>$newstitle</b></font><br>");
        print("<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">Posted by
                <a href=\"http://forum.ymuk.net/member.php?action=mailform&userid=$newsposterid\">$newsposter</a> on $newsdate
                <br>$newstext<br><a href=\"http://forum.ymuk.net/showthread.php?threadid=$newsthreadid
                  \"><br>($newscomments comments...)</a></font></br></p>");
        }

?>