Latest Thread in template footer

[anhvienls]

I need mod, It can show latest thread in template "footer". I was found in vb.org but not see.
I have 1 php code can get lastest thread from db. This mod such as webmastershelp.com. I like this mod. Who help me?

Thank

PHP Code:

<?php 
$db_host = "localhost";
$db_name = "databasename";
$db_user = "username";
$db_pw = "dbpassword";

$forum_url = "http://www.webmastershelp.com";
$limit = "5";
$postedcolor = "#404040";
$fontface = "arial,verdana,geneva";
$txtlimit = "50";
$num = "0";


mysql_connect($db_host, $db_user, $db_pw) 
OR die ("Cannot connect to your database"); 
mysql_select_db($db_name) OR die("Cannot connect to your database"); 

$tsql = mysql_query("SELECT threadid,title,postusername FROM thread ORDER BY threadid DESC LIMIT $limit");

while($tget=mysql_fetch_array($tsql))
{
$num = $num+1;
$title = $tget['title'];
$tid = $tget['threadid'];
$poster = $tget['postusername'];
echo "<strong>$num.</strong> <a href=\"$forum_url/showthread.php?t=$tid\">$title</a><br /><font color=\"$postedcolor\" face=\"$fontface\" size='1'><i>posted by $poster</i></font><br /><br />";
}
?>