Heres my site...look to the top right.
www.clockcrew.net I hope this is what you are looking for. You will need to edit a few things to fit your site.
PHP Code:
<? include("./global.php");
include_once("./includes/functions_bbcodeparse.php"); //for bbcodeparse2
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<?
/***********************************************************
** FileName:YOUR FRONT PAGE HERE
***********************************************************
** By MagicClock [MagicClock@gmail.com]
** File Description : 4-13-05 -- VB3 integrated front page
** File Version : 0.01
** File Comments : see source
\***********************************************************/
///////// CONSTANTS ////////////
$POSTLIMIT = 5; // number of last posts to display in the box
$PULLFROM = "INSERT FORUM IDS HERE"; //forums to pull last posts from
////////////////////////////////
///////// FUNCTIONS ////////////
function crtobr($convertme) {
//change carriage returns into br's
return $convertme;
//return str_replace(chr(13),"<br />",$convertme);
}
//////// GRAB LAST POSTS ///////////
$postitems = $DB_site->query("SELECT * FROM thread WHERE `forumid`='".str_replace(",","' OR `forumid`='",$PULLFROM)."' ORDER BY `dateline` DESC LIMIT ".$POSTLIMIT);
if ($DB_site->num_rows($postitems) > 0)
{
$postchunk = "";
while ($qx = $DB_site->fetch_array($postitems))
{
$postchunk .= "* <a href=\"bbs/showthread.php?t=".$qx["threadid"]."\">".$qx["title"]."</a><br>";
}
}