function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{
        include_once "path/to/GLOBALS.php";

        $cid = mysql_connect($MYSQL_SERVER, $MYSQL_LOGIN, $MYSQL_PASSWORD);
        $r = mysql_db_query($MYSQL_DB, "SELECT
                                                fud_msg.id,
                                                fud_msg.subject
                                        FROM
                                                fud_thread
                                        INNER JOIN fud_msg
                                                ON fud_thread.root_msg_id=fud_msg.id
                                        WHERE
                                                fud_msg.approved='Y'
                                        ORDER by
                                                fud_thread.id DESC
                                        LIMIT ".$n_posts, $cid);
        while( $obj = mysql_fetch_object($r) ) {
                /* Here you do your actual code, below is a working example */
                echo "<a href=\"".$WWW_ROOT."msg.php?goto=".$obj->id."\& quot;>".$obj->subject."</a><br>\n";
        }
        mysql_free_result($r);
}

function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{
        include_once "path/to/GLOBALS.php";

        $cid = mysql_connect($MYSQL_SERVER, $MYSQL_LOGIN, $MYSQL_PASSWORD);

        $r = mysql_db_query($MYSQL_DB, "SELECT resource_id FROM fud_group_cache WHERE user_id=0 AND p_VIEW='Y'", $cid);
        $lm='';
        while( list($id) = mysql_fetch_row($r) ) $lm .= $id.',';
        $lm = substr($lm, 0, -1);

        $r = mysql_db_query($MYSQL_DB, "SELECT
                                                fud_msg.id,
                                                fud_msg.subject
                                        FROM
                                                fud_thread
                                        INNER JOIN fud_msg
                                                ON fud_thread.root_msg_id=fud_msg.id
                                        WHERE
                                                fud_thread.forum_id IN (".$lm.") AND
                                                fud_msg.approved='Y'
                                        ORDER by
                                                fud_thread.id DESC
                                        LIMIT ".$n_posts, $cid);
        while( $obj = mysql_fetch_object($r) ) {
                /* Here you do your actual code, below is a working example */
                echo "<a href=\"".$WWW_ROOT."msg.php?goto=".$obj->id."\& quot;>".$obj->subject."</a><br>\n";
        }
        mysql_free_result($r);
}

echo mysql_error();

function fetch_forum_posts($n_posts) /* n_posts is the number of messages you wish to fetch */
{
        include_once "forum/fud/include/GLOBALS.php";

        $cid = mysql_connect($DBHOST, $DBHOST_USER, $DBHOST_PASSWORD);
	$tbl = $DBHOST_TBL_PREFIX;
        $r = mysql_db_query($DBHOST_DBNAME, "SELECT resource_id FROM ".$tbl."group_cache 
                                        WHERE user_id=0 AND p_READ='Y'", $cid);
        $lm='';
        while( list($id) = mysql_fetch_row($r) ) $lm .= $id.',';
        $lm = substr($lm, 0, -1);

        $r = mysql_db_query($DBHOST_DBNAME, "SELECT
                                              ".$tbl."msg.id,
                                              ".$tbl."msg.subject,
                                              ".$tbl."thread.last_post_date,
                                              ".$tbl."thread.last_post_id
                                        FROM
                                                ".$tbl."thread
                                        INNER JOIN ".$tbl."msg
                                                ON ".$tbl."thread.root_msg_id=".$tbl."msg.id
                                        WHERE
                                                ".$tbl."thread.forum_id IN (".$lm.") AND
                                                ".$tbl."msg.approved='Y'
                                        ORDER by
                                                ".$tbl."thread.last_post_id DESC
                                        LIMIT ".$n_posts, $cid);
        while( $obj = mysql_fetch_object($r) ) {
                /* Here you do your actual code, below is a working example */
                $tm = date("d/m/Y H:i", $obj->last_post_date);
                echo $tm." - <a href=\"".$WWW_ROOT."index.php?t=msg&goto=".$obj->id."\">".$obj->subject."</a> 
                <a href=\"".$WWW_ROOT."index.php?t=tree&goto=".$obj->last_post_id."\">&raquo;&raquo;&raquo;</a><br>\n";
        }
        mysql_free_result($r);
}