Newest Posts on Main page

Is there a hack that lets you put the most recent posts in the forum on the main page of your site?

Where can I get it?

I search too this hack

I searched it in my last thread "help*_*", too.

Have nobody make one jet?

I've seen this in action on Sitepoint so it can be done.
How being the definitive question

PHP Code:

<?php
// Set this to the max number of threads to display
$maxthreads = 10;

require("./admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<a href=\"showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</a>";
}
 
?>

Ratorasniki, do I just copy & paste that code onto my main html page to get these Topics to show up there?

Firstly thanks for the help really aprreciate it.

i tried pasting the code into my page but it generated a parse error on the line with the SQL query on it.

echo "<a href=\"http://www.yoursite.com/path_to_forum/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</a><br>";

Change this and it works perfect. Thanks Ratorasniki *_*

$servername="****";
$dbusername="****";
$dbpassword="****";
$dbname="****";

At this instead of "require("./admin/config.php");" Zeus.

I tried that it still dosent work, again the error is with the SQL query statement.

I'm using php3 will that make a difference?
(I have made the necessary php3 extension changes)