OK here is what I have for you.....This will display the last 5 threads that were posted to on your homepage.
Check out the result here:
http://www.extremeforums.com/include/active.inc.php
Place the code below into a file called "active.inc.php"
<?php
// Set this to the max number of threads to display
$maxthreads = 5;
require("config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
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 "<FONT SIZE=\"2\" FACE=\"Verdana, Arial, Helvetica, sans-serif\"> °
<A HREF=\"http://www.extremeforums.com/forums/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</A></FONT><BR>";
}
?>
On your homepage (where you want the list to appear add this code:
include("/full/path/to/active.inc.php");
Also you can edit the "echo" statement however you like....i just have them appear in a bulleted list with the font face that matches my site
Hope this helps,
~Chris
[Edited by TechTalk on 08-09-2000 at 07:34 AM]