if you know "very little" PHP, you can modify this code according to your needs:
-- cut --
<table width="100%" border="0" cellspacing="1" cellpadding="00">
<?php
$servername= "localhost";
$dbusername = "username";
$dbpassword ="password";
$dbname= "dbname";
$forumlocation= "http://domain.com/yourboard/";
mysql_connect("$servername", "$dbusername", "$dbpassword") or die("Couldnt find MYSQL!");
mysql_select_db("$dbname") or die ("Couldnt find DB!");
// Get the latest 10 message from forum 15 and 4
$cekilen_mesleki=mysql_query("
select threadid, title, postusername, postuserid, dateline, forumid
from thread WHERE
visible= '1' AND (forumid='15' OR forumid='4')
order by dateline DESC LIMIT 10
");
if (mysql_error()) {echo "mySQL error:"; echo mysql_error(); exit;}
$mesleki_number=mysql_numrows($cekilen_mesleki); //number of news fetched
if ($mesleki_number<=0) {echo "<tr><td bgcolor=\"#FFFFFF\">No New Message!</td></tr>";}//no news on database!
else {
$ii=1;
while ($gelen= mysql_fetch_row($cekilen_mesleki))
{
if ($ii % 2) {$tdcolor="#FFFFFF";} else {$tdcolor="#eeeeee";}
echo '<td><td bgcolor="'.$tdcolor.'"><a href="'.$forumlocation.'showthread.php?s=&threadid ='.$gelen[0].'">'.$gelen[1]."</a><br><i>".$gelen[2]."</i> ";
echo "</td></tr>";
$ii++;
}
} //else kapa parantez
?>
</table>
-- cut --
1- Make the necessary modifications (password, db name etc..)
2- Rename index.html to index.php in
www.mysite.com
3- Insert this code to the relevant part of index.php in
www.mysite.com